Discussion Board for collaboration related to QlikView App Development.
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!
You can use rowno() in your expression to get costume subtotal.
for more details follow below link.
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