Help on Intersect

[srik00001]

Hi all,

I am trying to build an intersect calculation

=

count({$<VALUE_KEY=

P({<CUSTOMER=, SOURCELEVEL2=P(SOURCELEVEL2)>}VALUE_KEY)   

        *

P({<CUSTOMER={'Customer X'},SOURCELEVEL3=P(SOURCELEVEL3)>}VALUE_KEY)

>} DISTINCT VALUE_KEY)

The table has Customer as a dimension. How do i pass the Customer dimension value at each row into the second part of the intersection calculation while the first part looks at all customers.

Thanks for your help

[swuehl · Accepted solution]

There is no way to pass a dimension's row value into a set analysis expression.

A set expression is evaluated once per chart, not per dimension row.

edit: see this classic post for more details:

Evaluating "sets" in the context of a dimension