5 Replies Latest reply: Apr 15, 2011 5:18 AM by Jason Michaelides RSS

    Set analysis to SUM values implied by current selections

    Jason Michaelides

      Hi all,

      I'm close to this I think but can't get the syntax right - hoping someone can help!

      Say I have 3 list boxes:

      1. Product
      2. Colour
      3. Size

      If I select a particular Product (e.g. Shoe123) I can see (in white) all the Colours and Sizes that product has been sold in. I can see the total sales for my selections with SUM(Sales). What I want to see is the TOTAL sales for all the Colours and Sizes that Shoe123 has been sold in. This should be the same value as "selecting possible" from Colour and Size then deselecting Product.

      Pretty sure I need to use the P() element function...I think!

       

      Thanks in advance,

      Jason