topic Pivot Table Subtotal in QlikView

Pivot Table Subtotal

tigerfan81 — Thu, 08 Mar 2012 19:09:56 GMT

Attached is a simple pivot table....

Actual Billing sum(Actual Billing)

Base Billing sum(Base Billing)

Why would actual billing total and base billing does not?

Any help would be appreciated....

Thanks,

Re: Pivot Table Subtotal

swuehl — Thu, 08 Mar 2012 21:07:58 GMT

A pivot table total is evaluated as expression total (like in a text box). It is not a sum of rows and you can't choose from the total mode options that are enabled in straight table only.

I assume your base billing values have a different / unlinked relation to your dimension values than your Actuals, so you get a total in all lines. If you want to use a sum-of-rows also for a pivot table total, check out the chapter in the Help, it's explaining of how you can do this using advanced aggregation.

It will look like:

= sum( aggr( sum( [Base Billing]), [End Date]) )

Hope this helps,

Stefan

Re: Pivot Table Subtotal

Anonymous — Fri, 09 Mar 2012 05:38:45 GMT

You just check the chart properties --> Total mode --> whether the two expression check same total property or

not.

see the attached image

Regards

Ashok