Set Analysis | Dimension1 = Dimension2

[jdmarlin]

Hello,

I'm trying to do a set analysis where one dimension equals another. So in the sample below I want three results (in bold) to show up:

Year	Product	Customer	SubCustomer	Balance	Correct Results
2015	1159	2000005	2000005	-50000000	-50000000
2015	1159	2000007	2000005	-64050000	0
2025	1159	2000005	2000007	-50000000	0
2025	1159	2000007	2000007	-64050000	-64050000
2025	1159	2000005	2000005	-50000000	-50000000
2025	1159	2000007	2000005	-64050000	0

I've tried Sum({<Customer=P(SubCustomer)>} Balance), but that doesn't seem to work.

[swuehl · Accepted solution]

Set analysis is evaluated once per chart, not per dimension line.

=Sum( If(Customer = SubCustomer, Balance))