topic Pivot table Subtotal on each row in QlikView

Pivot table Subtotal on each row

Fri, 09 Mar 2012 09:19:36 GMT

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 — Fri, 09 Mar 2012 09:34:27 GMT

Hi,

Have you tried with using the expression with groups

Sum(TOTAL <Tipo> Invoice)

Celambarasan

jagan — Fri, 09 Mar 2012 10:05:10 GMT

Hi,

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

Regards,

Jagan.

Fri, 09 Mar 2012 10:05:23 GMT

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

Fri, 09 Mar 2012 10:09:40 GMT

Thank you so much.

You are Great !!!