MonthYear MonthYear - 1 in Bar Chart

[Anonymous]

All,

I am trying to create a bar chart that has 1 dimension MonthYear with no selections.  I want to show quantity of current month and last year same month.

Any advice on the formulas to do so?

Thank you!

[Gysbert_Wassenaar]

If you're using MonthYear as a dimension and want to show each MonthYear along with its corresponding month from the year before you neeed an AsOf table that links each MonthYear value with it corresponding year-before month. See this document: Calculating rolling n-period totals, averages or other aggregations

[#3]

Hi

Try this in your expression

=SUM({<[Date Field]={">=$(=MonthStart((Max([Date Field])))<=$(=MonthEnd((Max([Date Field])))"},Year=,Month=,Quarter=>

+

<[Date Field]={">=$(=MonthStart((Max([Order Date])),-12))<=$(=MonthEnd((Max([Date Field]),-12))"},Year=,Month=,Quarter=>}Fieldname)

-12 here specifies the same moth in previous year

[Anonymous]

This is not working... I am only using MonthYear as my dimension.

[#5]

Hi,

This is working for month year dimension too if possible pls post your sample file

[Anonymous]

here is a screen shot

[#7]

Can you post a sample app with small data?

[Anonymous]

Here is a sample file.