
Re: Clarification on set analysis use of P() for current dimension value
pablo trevisan Aug 23, 2018 11:12 AM (in response to Dan Dalnekoff)Hi Dan, you could use this expression.
Once for each Typeexample:
IF(sum({$<Type ={'Dairy'} >} [Amount Spent]) > '0',SUM({<Type = {'Dairy'}>}[Amount Spent]),0)
IF(sum({$<Type ={'Bakery'} >} [Amount Spent]) > '0',SUM({<Type = {'Bakery'}>}[Amount Spent]),0)

Re: Clarification on set analysis use of P() for current dimension value
Dan Dalnekoff Aug 26, 2018 9:54 PM (in response to Dan Dalnekoff)Olivier, Pablo  thank you both for your replies. Both of your solutions did correctly solve the example I provided, and these were helpful solutions in achieving my goal. My exact scenario was a bit more complex than I had the example (as I realized while working through it) to be, but I was able to leverage what you outlined to solve my challenge.
thanks again,
DD

Re: Clarification on set analysis use of P() for current dimension value
Andrey Krylov Aug 27, 2018 2:50 AM (in response to Dan Dalnekoff)Hi, Dan, try this expression for Dairy
Sum(Aggr(Sum(TOTAL < Customer > Aggr(Sum({< Type = {'Dairy'} >} [Amount Spent]), Customer) ), Product, Customer, Type))
