Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Sheet properties>Triggers >OnActiveSheet >Action> Field = Location & Search String ='Mumbai'
Regards-bika