Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have 2 fields for months and 2 for years
month1,month2,year1,year2
suppose the user select july from month1 and year1=2013
and select february from month2 and year2=2014
in the chart i'm displaying the sales within this period
i.e the month is the dimension and i have 2 expressions:
1- sum(sales) for the selected period
2-sum(sales) for previous year period (from july 2012 to february 2013)
what i want is to sort the dimension of the month in the chart to be july-august-september-oct-nov-dec-jan-feb
because the chart sort them as jan-feb-july-august-....
So,,How can i sort the dimension?
Thanks in Advance.
Hi Mona,
Let try to sort dimension by expression. Right click on chart -> Properties -> Sort -> Check on Expression then using
(YearField*100)+Num(MonthField)
Regards,
Sokkorn
Hi Sokkorn,
no not working !
Hi Mona,
Can you share your app?
Regards,
Sokkorn
Hi,
You can also try this in your sort expression and then sort Ascending:
if (month_fld='Jul',1,
if (month_fld='Aug',2,
if (month_fld='Sep',3,
if (month_fld='Oct',4,
if (month_fld='Nov',5,
if (month_fld='Dec',6,
if (month_fld='Jan',7,
if (month_fld='Feb',8))))))))
Regards,
Abey
i have 2 month fields month1,month2 and 2 year fields year1,year2.
Also, the user may select another period next time may select for example from may 2013 to mar 2014 and so on
Hello Mona,
which dimension month are using to plot your chart? Month1, month2 or another one?
Here you have an example
Sorry, because my QV is in Spanish.