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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-07-31 01:46 PM

Using pivot table partial totals to create a graph

Hi everyone,

Is there a way to store the "show partial sum" value from a pivot table? I want to use these values to create a graph, but have been unable to find any discussions on the matter. I don't see another way to dynamically create the sum of each column in my pivot table, so please let me know if there's a way.

Thanks in advance for your help.

Best,

Barbara Cleary

Additional details on the project I'm working on if need be:

  • I created a pivot table which calculates the affect of price/volume/mix in my department's margin. Dimension is each customer.
  • I have "show partial sum" selected in order to sum the affects of price/volume/mix for all customers.
  • I'm looking to create a waterfall graph to "walk" from margin in one month to margin in the second month.
  • This would show the dollar effect of volume, price, and mix as a whole for all customers combined
587 Views
0 Likes
0 Replies