Chart Expression aggregation

[arsenal1983]

Hello, 

I have an issue with my chart (table) expression. 

The Total Count expression appears only in one row for each PATY/MONTH. I need to have it in every row.

Dimensions:

PATY and MONTH comes from the source detail data,

CATEGORY is calculated dimension - combined if and class function

Expressions:

SELLERS COUNT =count(DISTINCT BER.SELLER_SID)

TOTAL COUNT = aggr(count(DISTINCT SELLER_SID), MONTH, PATY)

How can I reach such effect?

[stevejoyce · Accepted solution]

try TOTAL COUNT = aggr(nodistinct count(DISTINCT SELLER_SID), MONTH, PATY)

or i think this should work also...

count(Total <MONTH, PATY> DISTINCT SELLER_SID)

[marcus_sommer]

Try it with:

TOTAL COUNT = sum(aggr(count(DISTINCT SELLER_SID), MONTH, PATY))

- Marcus

[arsenal1983]

that works: 

TOTAL COUNT = aggr(nodistinct count(DISTINCT SELLER_SID), MONTH, PATY)

[arsenal1983]

it only change that I got 0 instead of null.