topic Pivot Table: Showing Total Sum in QlikView

Pivot Table: Showing Total Sum

Mon, 23 Jun 2014 15:03:52 GMT

Hello!

I have a Pivot Table with the following data:

The thing is that the total for Account is 3 because it counts 3 unique Accounts, but I'd like to see it as 4 (the number of rows).

I also have an expression at the right that counts the distinct Account IDs in this table.

I believe you can solve this in the Straight Table when you put Sum of Rows under Expression tab.

Is there any way to do something like that in Pivot Table?

Thank you!!!

Mon, 23 Jun 2014 15:05:47 GMT

Could you share a sample qvw?

TKendrick20 — Mon, 23 Jun 2014 15:06:45 GMT

Count Account IDs, not distinct Account IDs? That should give you 4.

Or use a straight table.

jaimeaguilar — Mon, 23 Jun 2014 16:15:59 GMT

Hi,

Maybe Count(Distinct AccountID & Action)

regards