Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Well then you need to add all Date Fields to your set like
=count({<Year= , Quarter=, Week=,Month=,Date= , [Stock Type] = {'S'}, MFG_SOURCE_LOCATION_ID = {'PR01'}>} MSG_PROCESSED_FLG)
Try
[Area Name] =P( [Area Name] )
Edit: Or maybe you don't use 1 but instead use [Quarter-Year]=
count({<[Stock Type] = {'S'},MFG_SOURCE_LOCATION_ID = {'PR01'}, [Quarter-Year]= >}MSG_PROCESSED_FLG)
try like above post, as Michael Said, if your [Quarter-Year] is one field.
if Quarter and Year are separate fields then try like below
=count({<Year= , Quarter= , [Stock Type] = {'S'}, MFG_SOURCE_LOCATION_ID = {'PR01'}>} MSG_PROCESSED_FLG)
Thank you all, But if I select a Quarter-Year or Month or date in the filter box it is narrowing the results. At any given time all Quarter-Year should be visible and only change when an AREA NAME is selected
Well then you need to add all Date Fields to your set like
=count({<Year= , Quarter=, Week=,Month=,Date= , [Stock Type] = {'S'}, MFG_SOURCE_LOCATION_ID = {'PR01'}>} MSG_PROCESSED_FLG)