Sales value comparing to last month in chart

[Anbuselvam K]

Hi,

I've attached the sheet with Pivot chart showing that each month sales quantity. I need all previous months sales value depend by current month value up to today.

For example today is 15-Mar-2016 and the sales value is 150. So in graph all previous months should show the value of sales up to 15th of that month. I would like compare all the month sales with the present month up to today date.

Thanks in Advance!

 

[Luke M]

Hello again.

Since you're using a PivotTable, I'd suggest creating a helper column in the source data to tick whether a record should be included or not, and then you can put that helper column in as a page field in the PT. Please see attached.

 

[Anbuselvam K]

Hi,

Thanks for your valuable answer and Sorry for late reply!

Is there any other way to get the same results in graph without pivot table.

Regards,
Anbuselvam K

 

[Luke M]

Sure, it just is more calculations. See here for an example.

 

[Anbuselvam K]

Thanks for your reply!