topic Subtotal in pivot table in QlikView

Subtotal in pivot table

Mon, 07 Jan 2013 19:12:48 GMT

Hi, a get this pivote chart:

I want to know how i get a subtotals for each Operador, like this:

Items 1,2,3 are calculated with an Count(Date). Is the only one field through which I can count.

Thanks for you help!

montero91 — Mon, 07 Jan 2013 19:27:47 GMT

Hi German

Try with:

= sum (Total <Operator> Value)

for the subtotals use <> after Total.

for percentages

=sum (Value) / sum (Total <Operator> Value)

whit format %

I hope to help you

Tue, 08 Jan 2013 03:55:10 GMT

Thanks Manuel ! Muchas gracias.