Grand Total Pivot table

[joeybird]

Hiya

I have lots of customers (Customer ID) that have orders under a department e.g  catering, finally  and sub specialties (plates)

I have a pivot table showing number of sales per month for year (2014) for each department, which you can expand to show the  sub specialties, number of sales

I would like to add a grand total column along the bottom for each month for each specialty

is this possible in qlik sense?

please help

[robert_mika]

Is this your after?

JS Pivot Table for QlikSense

[joeybird]

Hiya

would like to use expression, as some extensions are not supported on future updates

please help

[joeybird]

Hiya

https://community.qlik.com/servlet/JiveServlet/showImage/2-257612-21630/Total.png

here is a picture from a previous post. I need to find out the expression how to get the BOTTOM total lines for each month

e.g where it shows total '110'

and main total  '150'

please help

[#5 · Accepted solution]

Not sure its possible in Qlik Sense pivottables - although I am keen to be corrected!

Only thing I can think to mimic it, is a normal table with static fields such as:

SUM(IF [Department]='Catering',[Sales])

then use a drill down Dimension to get Department>Sub-specialty etc.

It won't look the same as your pivottable, but might be sufficient

[Michael_Tarallo]

Hello Joanna,

Is this for Qlik Sense?

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[joeybird]

Hiya

the extension format is exactly what I need, but I am steering away from using extensions

please can the Qlik team develop the total bar for the current pivot table contained within qlik sense

Kind Regards 

[joeybird]

Hiya

I took on Board your idea, but I found best using a bar chart

thank you Andrew x

Kind Regards

[#9]

Is it possible yet to generate a grand total line for measures in columns, for pivot tables?  I see the answer above is from 2015, so I'm hoping things have changed since then.

Thanks.