Totals to the right for each dimension value (Pivot Table)

[satishkurra]

Hi

I'm trying to achieve to display the totals to the Right on each Account ID.

With No Total Pivot. png is what I'm getting.

I need to achieve With Total Pivot.png

Can some one help in achieving this?

Thanks

Satish

[satishkurra · Accepted solution]

Never mind. This is a foolish question.

I added an another measure with Amount 1 + Amount 2 + Amount 3 and remove partial sum option.

Worked.

Thanks

[Digvijay_Singh]

May be something like this -