11 Replies Latest reply: Jun 8, 2011 8:11 AM by Sridhar Ethiraj RSS

    *** Yet another Set Analysis Question ***

    Deepak Vadithala

      Dear All,

       

      I have quick question on one of the expressions. Here is the expression...

       

      =SUM({1<FYrNum = {$(=Only(FYrNum)-1)}, StoreName = {"*"}>} NetSales) / 1000000

       

      I am sure this should be pretty simple to solve... but I am struggling to get my head around this one.

       

      I have two list boxes : FYrNum & StoreName

       

      If the user selects 2010 in FYrNum (Listbox) I wanted to show the data for previous year, however user will also filter for the StoreName. My Current expression (above stated) doesn't filter on StoreName because we are using {1} and it just shows the data for all the stores.

       

      So I need the data for FYrNum when the user selects the years and if the users selects the StoreName I wanted the data to be filtered on StoreName as well. I am using all this in one Guage chart.

       

      I think I need to use SET OPERATOR to get this working but I am struggling to get this working.

       

      Many thanks in anticipation.

       

      Cheers - DV