take previous month data in pivot

[surajdhall]

Hi All,

When there is no data available in the current month, i want to bring from previous month in the pivot table (attached file)

Product B- High has no data in Feb. So take 86.20% from previous month.

Product C- Low has no data in the May. So take 100% from previous month.

I want to do this in this chart locally, is it possible?

[surajdhall]

Thanks for clarification.

[stevietm]

Hi,

I would just like to find out what would you do in a case where there are multiple months that has no value? 

I have multiple months and the before function can only do that for one month.