Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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!

Labels (1)
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.