4 Replies Latest reply: May 23, 2011 9:23 AM by Richard Taylor RSS

    Total Sales

      Hi all,

       

      I have a straight displaying a number of expressions, but I need to display the total historical sales as an expression that is not affected by any selections, If I use set analysis ({1< etc is expands the whole table and will not therefore allow any selections to reduce the data to an indiviidual product or item.

       

      Can anyine tell me how I achieve this?

       

      The Straight table has 3 dimensions, Item Short Name, Supplier & Platform.

       

      =sum({<[SOP Type]={'Invoice'}>} Quantity) - is my current solution

       

      I had thought aout displying this info as a calculated dimension? Is this possible?

       

      Regards

       

      Richard