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]

How you are align the trigger. Can you tell us your procedure

[#3]

Document properties >on open >add actions>

1. clear all

2.select in field(Month=Max(Month))

Pls correct me,if am any wrong

[prieper]

you need to include in ""

Peter

[avinashelite]

Check the field Month format ..

Max(Month)) this will give the number format

convert it to the format as per the Month field

monthname(Max(Month))) or to the format Month field is

[Anil_Babu_Samineni]

Check here

Note: If it not working could be Max(Month) reads as Number. Can you check in KPI and then see how it returns

[#7]

Still not getting what am exactly looking for.............

Pls suggest if have any more ideas???

[avinashelite]

share your app !! we will make it work for you

[#9]

Hi,

Share sample data. It will help to resolve/suggestion real fast. Whats your date format ??

[#10]

Hi,

Thanks for your replay

Here Max Month is Dec but which has no data only March has data

So I want to the see data of Mar by default and if I clear all the selections

Also I dont want to see any selection in the list box but I want to see Max month of data.

Is it possible???

PFA for your reference!!