7 Months Filter

[Kamohelo]

Hi 

I would like to display 7 months data on a crosstab (Current month and 6 months prior).

Is there any suggestions i can use to achieve this?

Regards

[Sam_SAS · Accepted solution]

You could use an advanced filter expression like this:

( TreatAs(_Number_, DatePart(Now())) - TreatAs(_Number_, 'Facility Opening Date'n) ) <= 210

This selects the last 210 days of rows. I'm not sure if you can make a filter that selects on months intelligently that would span years.

Sam

[Kamohelo]

Hi Sam,

Thank you - It worked.

Kamo