Repeat amount for specific dimension

[l_denivelle]

Hi

I have 2 amounts to calculate that I have to repeat per customer who belongs to Group.

Example :

Customer	Group	Salary mass	Amount 1 (sum per Customer)	Amount 1 (per Group)	Amount 2 (salary mass - Amount 1)
1	A	10 000€	1 000€	700€	9 000€
1	B	10 000€	1 000€	300€	9 000€
2	C	25 000€	12 000€	2 000€	13 000€
2	D	25 000€	12 000€	8 000€	13 000€
2	E	25 000€	12 000€	2 000€	13 000€

I tried with AGGR() or TOTAL function and I didn't manage to get the results of Amount 1 (sum per Customer) and Amount 2 (salary mass - Amount 1)

I will be grateful if you have any solutions for this case.

Thank you !

[sunny_talwar · Accepted solution]

Try TOTAL qualifer with Customer field name -> TOTAL <Customer>

1) Sum(TOTAL <Customer> [Amount 1])

2) Sum([Amount 1])

3) Only([Salary mass]) - Sum(TOTAL <Customer> [Amount 1])

[l_denivelle]

Cool ! it works. I didn't know I could use TOTAL function like this.

Thank you