Pivot table Subtotal on each row

[#1]

      HI all,

      Problem:

     I would like show the subtotal near each row dimension , because I have to calculate a percentage row/subtotal.

      I tried with aggr o dimensionality I have not found the solution.

      This example that I posted (qvd attached) is not the real case but it is an easy way to explain the problem

       Many thanks in advance

      Claudio

[CELAMBARASAN]

Hi,

     Have you tried with using the expression with groups

     Sum(TOTAL <Tipo> Invoice)

Celambarasan

[jagan · Accepted solution]

Hi,

Check the attached file for solution.  Hope it helps you.

Regards,

Jagan.

[#4]

Thank you for your replay but in my case doesn't work.

That i need is

To show near each row Order the Subtotal of dimension Invoice

___________________________________________________________

The previous replay doesn't work because i will obtain the follow result:

I need to have the Subtotal not the grand total

[#5]

Thank you so much.

You are Great !!!