Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart that i added text to that shows the months the user is looking at. The trouble is that the Months come out in Alphabetical order. I want to see them in the order they are on the calendar. I have tryed everything i know and i cannot get this to work.
Any direction would be greatly appreciated
Thanks
Karen
Hi, Use Dual() Function to make to calendar order. Expression Should be something like below.
=Dual(Expression_With_Month,Month)
-Sridhar
I don't mean to be dense...I am new to this...
=if ( count ( distinct GraphData.GMonth) = count( distinct
GraphData.GMonth), 'YTD', if ( count ( distinct GraphData.GMonth) ,
concat ( distinct GraphData.GMonth, ', ' ) ))
This is the expression I am using and I am unfamiliar with a dual
expression...where do I put the dual? At the beginning or instead of
the concat? Or somewhere else altogether?
Karen
Should be some thing like this.
Dual(
if ( count ( distinct GraphData.GMonth) = count( distinct
GraphData.GMonth), 'YTD', if ( count ( distinct GraphData.GMonth) ,
concat ( distinct GraphData.GMonth, ', ' ) ))
, GraphData.GMonth)
EDIT:(untested Expression)
-Sridhar