Pivot Table: Sum of Rows?

[#1]

Hello,

I have a Pivot Table where there is something like this:

PRODUCT	ACCOUNT	COUNT
001	10	1
001	20	1
002	30	1
002	40	1
003	30	1
004	40	1
004	50	1
		5

But if I contract all, I see:

PRODUCT	COUNT
001       +	2
002       +	2
003       +	1
004      +	2
	5

Where:

- Product: Dimension

- Account: Dimension

- Count: Expression

The Expression Count is this:

COUNT (DISTINCT ACCOUNT)

So it counts the distinct accounts for every product

That's why it shows me 5 instead of 7...

I'd like to show the value as a Sum of Rows (like in Simple Table, but I need to use this Pivot Table), in order to show me 7.

Do you know how could I do this?

Thank you!

[er_mohit]

Try this expression

Count(TOTAL <PRODUCT> ACCOUNT)

[PrashantSangle]

Hi,

When you are using DISTINCT , It will give you count of only Distinct Account which is in your case

10,20,30,40,50

Therefore it is showing you Count =5,

If you want to Count of All account even if they are repeated then try with

Simple count(ACCOUNT) instead of trying with count(distinct ACCOUNT).

Or you can try with Aggr() also,

Like,

AGGR(count(distinct ACCOUNT),PRODUCT)

Regards,