cancel
Showing results for 
Search instead for 
Did you mean: 

Design Studio Percent Of Total Calculation

Former Member
0 Kudos

Hi,

We have hit this issue where we want to show the Percent of Total in design studio crosstab.

Say i have data in below format which is attached to a cross tab. All this data is coming from the Data Set.

Company SalesSales% Total
A3030%
B2020%
C4040%
D1010%
Total100100%

Now when i filter the data it shows up as below, see the percentage it is not showing now % of total

Company SalesSales% Total
A3030%
B2020%
Total5050%

We actually want it to be shown as below

Company SalesSales% Total
A3060%
B2040%
Total50100%

Is there a way to do this in Design Studio? Any help is much appreciated.

Regards,

vipul

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Design Studio Crosstab Component does not provide option to calculate new Column in it .

You can try following .

1) Create Custom Component for Tabular data which can provide you this facility.

Or

2) Calculate it at Data Source Level .

MustafaBensan
Active Contributor
0 Kudos

Hi Nikhil,

If i have understood correctly, I don't think the requirement is to add a calculated column to a crosstab.  It is already being calculated in the data source.  The issue seems to be that when a filter is applied, the calculated column in the data source is not recalculated based on the filtered rows.

Regards,

Mustafa.

Answers (5)

Answers (5)

Former Member
0 Kudos

there is no solution as of now, you have to build it in universe or bex query.

Regards,

vipul

Former Member
0 Kudos

Hi,

Just to refresh the thread

I have the same issue, did you guys find some solution for that ?

Former Member
0 Kudos

BOE 4.1 SP2 Patch 1

DS 1.3 SP2

Former Member
0 Kudos

This is a universe based report.

If i have to write the query in universe then it will be like below

SELECT a1.State, a1.Sales, a1.Sales/(SELECT SUM(Sales) FROM Total_Sales) Pct_To_Total

FROM Total_Sales a1

But the problem comes when there is a where clause as seen below. I cant propagate it to both the select in the below query

SELECT a1.State, a1.Sales, a1.Sales/(SELECT SUM(Sales) FROM Total_Sales where State IN ("DC","TX")) Pct_To_Total

FROM Total_Sales a1

where State IN ("DC","TX")

So i assume Design Studio cant be used to represent such data.

TammyPowlas
Active Contributor
0 Kudos

Vipul - thank you for clarifying that. Which version of BI are you using? Which version of Design Studio?

TammyPowlas
Active Contributor
0 Kudos

Agree with Nikhil - calculate this at the BEx Query level

Design Studio does not support local calculations