Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subtotal in pivot table

Hi, a get this pivote chart:

1.jpg

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

2.jpg

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

Thanks for you help!

1 Solution

Accepted Solutions
montero91
Creator
Creator

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

View solution in original post

2 Replies
montero91
Creator
Creator

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

Not applicable
Author

Thanks Manuel ! Muchas gracias.