Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have one issue with stright table.
i ave applied trigger on that. but when i select any one value in that table it is reflecting to next sheet.
but my req is ...wen i select dimension it should go to perticular sheet. other than any selection it should behave lik table only.?
how can i achieve this.
PFA
Thanks in advance.
HI,
You can disable expression selections
select the representation as link for all expressions
please see the attachment
Try with the alternate state .. that will help you to keep the selection to certain objects or pages
tried dat also but its nt givng the exct for dimensions?
PFA sample application
HTH
Vikas
Month dimension is used with alternate states.
Vikas
thnx vikas,
but my senario is diffrnt.
In my table i shud use trigger to redirect to one perticular sheet and any other selections done in that table it shud nt allow to select . it shud acts as a normal table?
I hope it is not possible, the reason is
When you select expression column, measure will be calculated based on the dimension (internally dimension will be selected). consequently your trigger is working..
a small workaround to overcome this situation, change all the expressions to calculated dimensions.
see the attachment, it might be helpful..
Edit: attached the file.
thnq pradeep...but in myy application wen i use calucluated dimensions it is shwng as error...?
you have to do aggr() based on all listed dimensions in the table..
but wen use for my expressions its nt wrkng i hve 8 expressions in my table