Set Analysis | Dimension1 = Dimension2

jdmarlin — Wed, 23 Sep 2015 21:51:48 GMT

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:

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

Re: Set Analysis | Dimension1 = Dimension2

swuehl — Wed, 23 Sep 2015 22:00:30 GMT

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

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