Count Distinct Total

[kevbrown]

I'm looking to create a table that looks distinct values and includes a total. However, using the total function on Dimension Limits is also distincting the values and therefore the amounts so match, for example

Status          Amount

a                    10

b                    20

c                    30

d                    40

e                    50

f                     60

g                    70

Total              250

I'm putting the data in NPrinting and need the total to be shown so can't use the function Total Mode on the Expressions tab as this doesn't pull into NPrinting.

Any idea?

Kev

[Gysbert_Wassenaar]

Try sum(aggr(count(distinct MyValue),Status))

[ashfaq_haseeb]

Hi,

Why don't you use default output of straight table.

Look at the attached application.

Or if you have non distinct values then use below formulae.

sum(aggr(sum(distinct Amount),Status))

Regards

ASHFAQ

[SergeyMak]

it's not clear for me but

try to use:

SUM(DISTINCT Amount) or

Sum(AGGR(SUM(Amount),Status)) or

IF(Dimensionality=0,SUM(Total Amount),Sum(Amount))

Please, share an app