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


    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...