Show previous month data, when there is no record

[Anonymous]

Hey, here is the screenshot of my current pivot table (QVW file attached)

What I am trying to achieve is something like:

If it is possible, I would like to be able to do that using expression.

Does anybody have any idea? thanks before

[antoniotiman]

Hi Mike,

remove '*Avg(1)' from Expression.

Regards,

Antonio

[Anonymous]

Hi!

it wont work if I select only 1 period. it will show in all period