Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Wonder if you can help me:
I want to create a chart/table where i can show previous fiscal year sales and current fiscal year sales in bar chart.
The trouble is current fiscal year is only till sept and previous fiscal year shows till december of this year.
I want the chart to show the sales of previous year only until the current month of previous year. My year starts from May.
below is the example of the chart. Can someone help please?
Basically we dont want to see data in previous fiscal year month until there is a date in the actual fiscal year.
Month | Actual | Previous Year |
May | 120 | 200 |
Jun | 130 | 150 |
Jul | 140 | 170 |
Aug | 150 | 380 |
Sep | 0 | 100 |
Oct | 0 | 450 |
Nov | 0 | 220 |
Dec | 0 | 120 |
Jan | 0 | 360 |
Feb | 0 | 200 |
Mar | 0 | 130 |
Apr | 0 | 470 |
May be this?
Sum({$<Year_Fiscal_Order = {$(=Max(Year_Fiscal_Order)-1)}, Month = {"=Sum({$<Year_Fiscal_Order = {$(=Max(Year_Fiscal_Order))}>}[Amount]) > 0"}>}[Amount])
Hi,
Let's see if this addresses your issue:
Use set analysis to filter out the actual number greater than zero.
Hope this helps.
Hi Sinar,
that doesn't work.
Attached is the app
Can you help on this?
Regard
May be this?
Sum({$<Year_Fiscal_Order = {$(=Max(Year_Fiscal_Order)-1)}, Month = {"=Sum({$<Year_Fiscal_Order = {$(=Max(Year_Fiscal_Order))}>}[Amount]) > 0"}>}[Amount])
Sunny,
You are a legend. I am out of words to thank you.
Can you also try and help on this as well if you can?
Re: Previous Fiscal Year data does not show up when i select date from calendar
Regards,
Sarb