Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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)
thanks for the response Shraddha,
but its not working, it showing from May to march...
It working at my end.
Can you share sample app?
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.