Create a Custom Subtotal at Bottom

[ksomosera10]

Hi,

Good day.

I was wondering if I can create a custom Subtotal for my Pivot Table.

Here's an example:

I have (5) columns named: Continent, Country, Sales 2018, Sales 2017, Percentage Diff.

I want to have a total sales for column "Sales 2018" and "Sales 2017"

at the same row where the Subtotal was, I want to calculate the percentage for sum of Sales 2018 and Sales 2017.

I hope I've make myself clear.

Please feel free to ask me for clarification.

Thanks in advance for your help!

[raman_rastogi]

Kevien

You can use rowno() in your expression  to get costume subtotal.

for more details follow below link.

https://www.qliktastic.com/2016/03/03/qlikview-pivot-table-average/

Raman

[vishsaggi]

May be use a dimensionality() function. Can you post a snapshot of your output I mean your pivot table snapshot. ?

Ref Check here:

Dimensionality for custom subtotal in pivot table

[ksomosera10]