Different Row and Column Totals in Pivot Table

[kevbrown]

I have a straight forward pivot table with 2 dimensions (Status, Date) and 1 expression (Count(ukmpsmr_risk.UMR). When looking at the pivot table (attached) in Qlikview I'm getting incorrect totals for June and October. On the attachment I've created an extra line called Correct Total. Any ideas?

Kev

[whiteline]

Hi.

The problem is in your data structure (duplicates or something).

For example, if you have one '10' value in a fact table, that is connected with more than one dimension value in other table you get different totals. '10' appears two times (rows) in pivot table for each dimension value but is used only once for total calculation.

[kevbrown]

is there a way of making the data and totals match?

[rajeshvaswani77]

Hi Kevin,

Is it taking values for 2012 as well?

thanks,

Rajesh Vaswani

[kevbrown]

Only from November 2012

[jonathandienst]

Kevin Brown wrote:

is there a way of making the data and totals match?

Something like:

     =Sum(Aggr(Count(ukmpsmr_risk.UMR), Status, Date))

HTH

Jonathan