Hello everyone, I have a pivot table that should display the last month spend in one column. It does so perfectly for the current month when filtering for two months, but not for the second month. Last Month Spend is a calculated field that uses periodOverPeriodLastValue: periodOverPeriodLastValu…

Hi @msedlmair , Please see this post for the solution and explanation. You will basically create a new calculated date field, and use that field as the filter for your visual rather than the billing period field directly. thank you. Asem

No data shown for last month when filtering for N months

Question & Answer

ErikG December 11, 2023, 2:57pm 2

Welcome @msedlmair

maybe you will find something here

You have to make sure not to filter out the relevant data.