Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Subtotal and Grand Total

I am sure I am missing something here, I would like to display sub-total and grand total in my pivot table where sub-total is at top of each group, while grand total is at bottom of the table (see a screenshot from my Excel).  However, I cannot seem to find a way to do this in QV, will someone be able to point me to the right direction?

2 Replies
Not applicable

Re: Subtotal and Grand Total


There is only one setting for top/bottom and it applies to all levels of totalling.Unless someone has a brilliant workaround, I am afraid that there is no simple way of doing what you want.



Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Subtotal and Grand Total


I was hoping this isn't the case, oh well. Thank you for your quick response.