Skip to Content
0
Dec 02, 2022 at 04:08 PM

SAP Analytics Cloud: Dynamic filter last day of last month

486 Views

Hello!

I have this requirement to show values for only the last day of the last month in SAC. At the moment they filter this manually using a fixed input control. Is there also a way to filter this dynamically?

Example:

Today is 2nd of December. I want to filter last day of last month, so 30th of November. Next month in January I want to filter on 31st of December.

Anyone an idea if this is possible in SAC?

Kind regards,

Bert