Previous Year Only but until current month of previous year

[#1]

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

[sinanozdemir]

Hi,

Let's see if this addresses your issue:

Use set analysis to filter out the actual number greater than zero.

Hope this helps.

[#3]

Hi Sinar,

that doesn't work.

Attached is the app

Can you help on this?

Regard

[sunny_talwar · Accepted solution]

May be this?

Sum({$<Year_Fiscal_Order = {$(=Max(Year_Fiscal_Order)-1)}, Month = {"=Sum({$<Year_Fiscal_Order = {$(=Max(Year_Fiscal_Order))}>}[Amount]) > 0"}>}[Amount])

[#5]

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