doubt

[#1]

Hi,

I have only 1 month of data and I created multiple objects in multiple sheets.

Now I have recieved next 2 months of data

I want to see the latest month of data if made no selections and by default

I did this by document triggers but not worked.

Any ideas??

[Anil_Babu_Samineni]

Check now

=Max({<id -= {'0'}>}month)

[avinashelite]

you this

=Max({<id = {"*"}>}month)

[#4]

Hi Avinash,

This is working fine for the specific object.

That's my dummy data In my original data there are multiple sheets with various charts/tables following by different dimensions and expressions.

So I want to see this by dynamic.

[#5]

I have already shared my sample data.

[avinashelite]

the logic which I shared will work with all the object which used the id count ....if you have different combination and need to set the month according to that then go for sheet level triggers and set that according to your requirement