Date calculations

[#1]

Hi,

i have a requirement

i need to show 4months before data when i select month in straight table, if nothing is selected should show all data

i need same solution for weeks and quarters

please help

Thank you

[ecolomer]

see this example

[MK_QSL]

Please check enclosed file showing table needed for YearMonth selection..

Same way you can create Quarter formula...

In case, user select more than one YearMonth,

change YearMonth with Max(YearMonth) in expression

[#4]

Thanks Enrique Colomer

Can you prove solution for below

1. i need to show 4weeks before data when i select week in straight table, if nothing is selected should show all

2. i need to show 4 Quarters before data when i select Quarter in straight table, if nothing is selected should show all

[ecolomer]

The examples I attached below runs with yours requeiriments