Previous month sales

[nagasekhar]

How will I get December sales value (2020) if I select January as month(2021)

[settu_periasamy]

Hi,

If you have YearMonth in your calendar table, You can use Date(AddMonths(Today(),-1),'YYYYMM') in your set expression.

[AshutoshBhumkar]

Hello,

@settu_periasamy  suggested correct.

If you have any sample data or scenario, we can help you in better way.

Thanks,

Ashutosh