Pivot Table: Showing Total Sum

[#1]

Hello!

I have a Pivot Table with the following data:

Action	Account
-	3
Selected	001
	002
Inspected	001
Planned	003

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!!!

[#2]

Could you share a sample qvw?

[TKendrick20]

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

Or use a straight table.

[jaimeaguilar]

Hi,

Maybe Count(Distinct AccountID & Action)

regards