Denominator Total Value to get Percentage on Aggr Value

[Bettegowda]

Hi,

I'm looking for help, Trying to get percentage value in the Pivot table.

Numerator is

Sum({<Dimension1 = {"=Aggr(Sum( MeasureColumn), Dimenstion1) >= 50"}>} MeasureColumn)

Can you please help getting the Denominator to get the total row level value for Dimension1

I used Total; however this is returning Total Value for the entire Dimension column

Sum(Total {<Dimension1 = {"=Aggr(Sum( MeasureColumn), Dimension1) >= 50"}>} MeasureColumn) (190)

		Dimension3
		ABC		BCD		CDE
Dimension1	Dimension2 (Aggr Value - Total Measure 1)	Measure Value	Measure %	Measure Value	Measure %	Measure Value	Measure %
A1	60	6	10%	12	20%	42	70%
A2	80	16	20%	16	20%	48	60%
A3	50	25	50%	10	20%	15	30%

Looking for expression to get Measure%

Thank you for helping.

[gavinlaird]

You can put a dimension in <> brackets to not disregard that dimension in the "TOTAL" calculation:

Sum( {<Dimension1 = {"=Aggr(Sum( MeasureColumn), Dimension1) >= 50"}>} Total <Dimension1> MeasureColumn)

[Bettegowda]

Thanks for the reply, I tried using <>  it looks like it is returning the numerator value not the total.

[Kushal_Chawda]

try this

Nr

Sum({<Dimension1 = {"=Sum( MeasureColumn)>= 50"}>} MeasureColumn)

Dr

sum(total aggr(if(Sum( MeasureColumn)>= 50,sum(MeasureColumn),0),Dimension1 ))