How to show data from the 12 previous months only?

[#1]

Hello everyone,

I have a pivot table in my sheet, where i need to show data only of the previous 12 months.

The date field of my data base is like that:

Thanks

[anlonghi2]

Hi Rodrigo,

please look at attached qvd where I used Group field to simulate your situation.

I made a little change to the calculated dimension.

Please let me know

Best regards

Andrea