Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to hide the Grand Total row in a pivot table without hiding the subtotals?
See screen shot
Yes. Totals in Pivot Tables are handled with Partial Sums on the Presentation tab. The grand total is the highest (first) dimension. Go to the Presentation tab, highlight the top dimension and remove the check on Show Partial Sums.
The other subtotals are hidden/shown based on the Show Partial Sum checkbox when other dimensions are selected on that tab.
Yes, I understand this but I would like the subtotals to still be displayed on the pivot table.
You can uncheck "Show Partial Sums" only for the first "Dimension" in Presentation tab.
Exactly. Each dimension has its own Show Partial Sums checkbox. The first dimension is the grand total. Your subtotals will have a separate checkbox. Go to that tab and highlight each dimension and you will see.
That works. Thank you very much everybody.
Hello Community Members,
The checkbox of the Paritial Sums is not enabled in my qlikview. I am using QlikView11 version
Thanks in advance
ramesh
I just solved this problem. Since this is the top-level result in Google, I wanted to help out others who might land here.
To make the Grand Total row disappear, I added an "if" statement to every expression. It referenced the top-level dimension, returning a NULL() if the distinct count of that dimension was greater than 1. This made every column NULL on the Grand Total row. With "Suppress Zero-Values" enabled and "Suppress Missing" grayed out in the "Presentation" tab of the chart properties, the Grand Total row disappeared.
I hope this helps!
Message was edited by: bhimes100. Spelling: changed "Supper" to "Suppress.
Please, check the correct answer.
thank you