month end Vs rolling weeks

[qv_testing]

Hi Community,

I have 2 tabs one for Revenue and second for Weekly data..

Revenue tab:  I have to show month list box January to October. (data should have associate Jan to Oct only)

this sheets effects Monthly once....

Weekly Tab:  Rolling weeks, have to show Current Month as well. (January to November and associate data Jan to Nov)

this sheet effects weekly reload.

how to manage Month End Process Vs Rolling weeks, please can you suggest?

Thanks in Advance.......

[Anil_Babu_Samineni]

Suggest to create MonthNum field in script using Number format to show number seq in Months

Num(Month(TempDate)) as Month_Num,

And then, It could be use this?

Sum({<Month_Num = {"<$(=Num(Month(Today())))"}>} Sales)

Sum({<Month_Num = {"<$(=Num(Month(Today())))"}>} Amount)

And same for Weekly report

Sum({<Month_Num = {"<=$(=Num(Month(Today())))"}>} Sales)

Sum({<Month_Num = {"<=$(=Num(Month(Today())))"}>} Amount)

[qv_testing]

Thanks for reply,

Actually i have many expressions, i can't change expression wise..

any possibility to set trigger level...??

If i create two calendar's will it work ??

[Anil_Babu_Samineni]

Trigger with sheet?? Or simple trigger for all sheets?

[qv_testing]

sheet wise trigger

[Anil_Babu_Samineni]

give it a shot, Because i don't have access to your file now due to client space

Anyway, Try this way

Create OnOpen Trigger and use Activate Sheet to First sheet object and use same as Further to add select using Month_Num as FieldName and string should be ='<' & Num(Month(Today()))

Same manner, Give it a shot as Sheet Activate from sheet level with same as action "Select in Field" to Month_Num as field name and String should be ='<=' & Num(Month(Today()))