Need Help

[help4qv123]

Hi Friends,

I need a help for cumulated month selection and mtd month selection.

There is a txt object which switches form YTD to MTD.

(For Ytd all month and for mtd single month.)

When YTD is (Switched )selected All the months till the selected month should be selected.

(If I select Jun the selection should be from Jan to Jun)

Again when switched form YTD to MTD then for Mtd Only june should be selected.

When switched from YTD to MTD

Please see the sample attached,.

[sunny_talwar]

Check the attached

I used  a select in field action

=If(Vtest = 'MTD', '(' & Concat({<MonthNum = {"<=$(=Max(MonthNum))"}, Month>} Month, '|') & ')', '(' & Concat({<MonthNum = {"$(=Max(MonthNum))"}, Month>} Month, '|') & ')')

Where MonthNum is created in the script like this

LOAD Month(Date#(Month, 'MMM')) as Month,

  Num(Month(Date#(Month, 'MMM'))) as MonthNum, 

     Data

FROM

[test.xlsx]

(ooxml, embedded labels, table is Sheet1);

[help4qv123]

Hi sunny Thanks for this.

But its just working on switching from MTD to YTD.

After switching form Mtd To YTD it shows. when i change the month selection form june to march or some other the cumulation of months should also effect that.

For example,June is selected in MTD and then when switched to YTD it selects from Jan to June.

When i change month selection suppose september then the same should effect on the month selection.

Means selection form Jan to Sep.

Thanks i Advance

[help4qv123]

Hi Sunny any clue on this

[sasikanth]

try this

Use Filed level trigger

Please check the attched application for reference

[sunny_talwar]

You might be able to do this, but I would recommend you against it because it is going to make your application very very complicated. I would suggest you to look into The As-Of Table‌ for the YTD information display. This will keep your application simple and without unnecessary triggers

[sunny_talwar]

Check the attached

[help4qv123]

Thanks sasi. My app does not have date and your expression looks too big

[help4qv123]

Ok i will check with this. I have made it but its too complicated and makes effect on performance. Thats the reson i am taking the help of you experts.

The sample which you have sent is Good. thanks for that.

I also want to do it with simple trigger. I will try that.