Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
MVP
MVP

Re: Subtotal and Grand Total

Hi

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.

Regards

Jonathan

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

Re: Subtotal and Grand Total

Hi,

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