Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
May be use a dimensionality() function. Can you post a snapshot of your output I mean your pivot table snapshot. ?
Ref Check here: