Sum Distinct problem

[timmy]

Hey,

I have a problem with this formula:

sum(distint Quata)

The dimension in the tabel is Salesperson and the problem is that we have two the same Quata's

Example:

SalesP1 650
SalesP2 650

If you take the formula sum(Distinct Quata) for this example you get 650 as total...

How can i solve this?

greetings

[#2 · Accepted solution]

Hi,

My suggest:

SUM(TOTAL AGGR(SUM(DISTINCT Quata), Salesperson))

[#3]

That's right, because of DISTINCT. It group the data first and does the SUM() after that. Use sum(Quata) to get 1300.

[timmy]

This is the correct formula but thanks for the help!

=

SUM(AGGR(SUM(DISTINCT Quata), [SalesPerson],Quarter))