Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I am creating stacked bar chart using my orederdate field for last 6 months sales.
dimension= Order date
for month year format i am writing below expression.
=Month([Order Date]) &'-'& Date(Date#([Order Date],'MM/DD/YYYY'),'YY')
it is coming last 6 months by writing my expression.
but months not showing order wise.
dec, mar,apr....like
i need order Jan feb mar...like that.please help on this.
Sort by expression: =[Order Date]
Hi
Use dimension and sort by expresion also,
=Month([Order Date]) &'-'& Year(Date#([Order Date],'MM/DD/YYYY'))