topic Create a Custom Subtotal at Bottom in QlikView

Create a Custom Subtotal at Bottom

ksomosera10 — Tue, 20 Feb 2018 05:43:12 GMT

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 — Tue, 20 Feb 2018 06:27:37 GMT

Kevien

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

for more details follow below link.

Raman

vishsaggi — Tue, 20 Feb 2018 06:36:31 GMT

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

Ref Check here:

ksomosera10 — Tue, 20 Feb 2018 06:42:50 GMT