Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try sum(aggr(count(distinct MyValue),Status))
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
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