How to sort the Bar chart to financial year

[laxmanqlik]

i have a bar chart with revenu and month fields,

now  i have to show the revenue of the financial year i.e, the dimension means month should start from April and has to end on March

please suggest me a way to solve.

thanks in advance...

[shraddha_g]

In Sort by Expression try:

Pick(wildmatch(Month,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar'),

1,2,3,4,5,6,7,8,9,10,11,12)

[laxmanqlik]

thanks for the response Shraddha,

but its not working, it showing from May to march...

[shraddha_g]

It working at my end.

Can you share sample app?

[jonathandienst]

There are plenty of examples here of how to correctly set up and perform fiscal period analysis using a master calendar. Search this site for master calendar and fiscal/financial periods and you should find a solution that works for you.