Help on Distinct count

[Sekhar8910]

Hi, I need help on distinct count

Below is the report structure

Customer Name   State   Region   Sales Centre
Raj                     AP   South        ABC
Sekhar                     MP   Central      TUV
Raj                     AP   South      DEF
Chandu                     HP   North      JKL
Bala                     MH   West      PQR
Sekhar                     MP   Central      XYZ

Output should be
Customer Name   Count distinct
Sekhar                          1
Raj                          1
Chandu                          1
Bala                          1
Total Number of Customers   4

Should count the total number of customers by distinct count. I have tried by Count( distinct [Customer Name] for [State],[Region],[Sales Centre]) but did not work.

Please help

[Lynn]

So the scope of distinct is across the whole report? Raj gets counted as 1 without regard to any other values? If so, try this:

Count( distinct [Customer Name] for report )

[Gowtami]

Hi Sekhar,
I have similar problem in one of my reports. Please share it, If you find any solution. I tried count distinct, it didn't worked for me. Mine is Power cube, a simple list report, and i need to count distinct employees for multiple pay periods in all locations. I tried to change measure rollup functionality in transformer and also few other trials, but endup with nothing.

Thanks,
Gowtami