Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I need some help. I have made an example table below, in this table I would like to get amount per Distinct Date, Distinct Group and Distinct Category. I can´t get it to work. For example for Date 2014-08-25 and Group A and Category C I would like to get 10 from the Amount column. Hopefully someone knows how to do it.
Date | Group | Category | Amount |
2014-08-25 | A | C | 10 |
2014-08-25 | A | C | 10 |
2014-08-27 | B | D | 20 |
2014-08-27 | B | D | 20 |
2014-08-29 | C | E | 30 |
Best Regards
Mårten
Hi,,
use below expression
=sum(aggr(sum(distinct Amount),Category,Group,Date))
Regards
ASHFAQ
Hi,,
use below expression
=sum(aggr(sum(distinct Amount),Category,Group,Date))
Regards
ASHFAQ
Hi,
Take these Date, Category , group as 3 dimensions for the straight/pivot table
and use the expression as
sum(distinct Amount).
Create a Straight Table
Dimension
Date
Group
Category
Expression
Only(Amount)
Or
SUM(Distinct Amount)
Thank you all, now I get it correct.
Regards
Mårten