Total is not for all columns working in Pivot Table

Thu, 26 May 2011 14:21:55 GMT

I'm working on a Pivot Table and trying generate some Totals and Subtotals. There are 6 columns and for 4 columns total is displayed and for other 2 it isnt working. I tried to lookup data in Excel sheet and it was recognising as TEXT in excel.

Then I have changed it to different format in QV chart properties, but still it isnt working. Any solutions to this?

Re: Total is not for all columns working in Pivot Table

johnw — Thu, 26 May 2011 23:21:28 GMT

In pivot tables, the total line is always calculated by applying your expression to the current data set. In other words, it completely ignores your dimensions. It does not do a sum of rows. That doesn't matter for some simple expressions like sum(Sales). But it can matter for other expressions.

To get a sum of rows in a pivot table, replace your current expression with this:

sum(aggr(YourCurrentExpressionHere,Dimension1,Dimension2,etc))

I don't know if this is the actual problem, but it's my only guess at this point.

topic Re: Total is not for all columns working in Pivot Table in QlikView

Total is not for all columns working in Pivot Table

Re: Total is not for all columns working in Pivot Table