Get amount by several distinct columns values

[#1]

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

[ashfaq_haseeb · Accepted solution]

Hi,,

use below expression

=sum(aggr(sum(distinct Amount),Category,Group,Date))

Regards

ASHFAQ

[#3]

Hi,

Take these Date, Category , group as 3 dimensions for the straight/pivot table

and use the expression as

sum(distinct Amount).

[MK_QSL]

Create a Straight Table

Dimension

Date

Group

Category

Expression

Only(Amount)

Or

SUM(Distinct Amount)

[#5]

Thank you all, now I get it correct.

Regards

Mårten