Sum by one dimension - exclude all other dimensions

[#1]

Hi All,

How to achieve "Amount Sum by P" in following table? There are dimensions from P to Z and I want Sum of Amount by P for each detail row.

P	Q	R	S	T	Amount	Amount Sum by P
A1	B1	C1	D1	E1	10	100
A1	B2	C1	D2		20	100
A1		C2	D2	E3	30	100
A1	B3	C2			40	100
A2	B4	C3	D2		50	180
A2	B5	C4	D2	E3	60	180
A2	B5	C5			70	180
A3	B6	C5	D2		80	80
A4	B6	C5	D2	E4	90	90

Thank You.

[Anil_Babu_Samineni]

This?

Sum(TOTAL <P> Amount)

[#3]

Hi Anil,

Thanks for the answer.

This breaks the detail data and group the data. I want the data structure to remain in tact.

I guess there should be some alternate.

One option is to add the measure in Master data of P to avoid any SELECTION filters on other dimensions.

Kind Regards,

Jigar Sanghavi

[Anil_Babu_Samineni]

I am not sure, Why not?

OR