Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

When Open Sheet fix loc='mumbai'

Dear All,

Whether it is possible to fix  dim = value when we open particular sheet.

Means suppose I have dimension location  and  value is mumbai  when user will open sheet I want mumbai is to

be selected to show graph base on fix location.

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
1 Solution

Accepted Solutions
prasad_dumbre
Partner - Creator
Partner - Creator

Hi Vikas,

Just apply a trigger on event of open sheet.

Add Actions -> Select in Field , give field name & the data which you want to select.

View solution in original post

2 Replies
prasad_dumbre
Partner - Creator
Partner - Creator

Hi Vikas,

Just apply a trigger on event of open sheet.

Add Actions -> Select in Field , give field name & the data which you want to select.

Not applicable

Sheet properties>Triggers >OnActiveSheet >Action> Field = Location & Search String ='Mumbai'

tri.bmp

Regards-bika