4 Replies Latest reply: Nov 13, 2013 3:10 PM by Alan Farrell RSS

    SET ANALYSIS

    Hardik Gandhi

      Hi all,

       

      I am having issue with a SET ANALYSIS applied on a bar chart.

       

      =count({1<[Stock Type] = {'S'},MFG_SOURCE_LOCATION_ID = {'PR01'}, [Area Name] = >}MSG_PROCESSED_FLG)

       

      But if we use 1 in the above SET analysis expression that will not allow the expression to change if I select AREA NAME it is not giving me the right count for that particular AREA NAME.

       

      The reason I am keeping 1 is because I want to display all the DIMENSION - Quarter-Year for the entire data-sheet at all time.


      Any suggestions...


      Thanks,

      H