how to get row wise total in pivot table

[Anonymous]

here i want to get sum of amount where reference is 1,2 and 3 , and that sum i want to be shown as row wise..

[Anil_Babu_Samineni]

Don't duplicate thread Re: sum based on dimension value in table

[Anonymous]

thats totally different problem Mr Anil Babu

[Anil_Babu_Samineni]

Not sure, What different it bifurcate for you? Can you explain how you want to show?

[Anonymous]

in this question i want row wise sum only , and the previous question was about getting % of the value,

as per the e.g

ref     amount      expression

1          10               16%

2          20               34%

3          30               50%

[Anil_Babu_Samineni]

Row level, You can define it as

Sum(Measure)/Sum(TOTAL Measure)

[sunny_talwar]

May be just this

Sum(TOTAL {<Reference = {'1', '2', '3'}>}Amount)