3 Replies Latest reply: Aug 9, 2011 2:27 PM by Aaron Couron RSS

    Set Analysis - Sum on the opposite dimension

    Aaron Couron

      I have items in categories that are either "included" or "excluded".  I need to create a straight table that lists the excluded items, but the calculation involves summing only the included items for that category.  (it involves some weighting of the actual price based on included items).So my problem is how to create a set analysis expression that sums included items while displaying only the excluded items.

       

      I am really just looking for the correct set analysis concept that will accomplish this idea.

       

      Thoughts?