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?