This content has been marked as final. Show 4 replies
Hi obieelearner ,
Thanks for your reply.
Maybe I do not express more clearly.
Firstly, the Sales1,Sales2,Sales3 is not different,but column.
The summary report contains five columns,such as
When users click any data in Sales1 column, it will navigate to Sales1 detail report,like:
When users click any data in Sales2 column, it will navigate to Sales1 detail report,like:
When users click any data in Sales3 column, it will navigate to Sales1 detail report,like:
I do not want to create three detail report, is it possible to implement one column to get the dynamical value,such as 'case when'?
Mainly, I do not know which measure users click .
Since you are using navigation for each Sales1,Sales2 and Sales3, try to pass a unique value (like S1,S2, and S3) to a variable or a place holder for each column so that in your detail report can know the Sales number(1,2, or 3)
in Your detail report you
Pull columns region,quantity,price, Sales
In the last Sales column use expression like
when variable ='S1' then Sales1
when variable ='S2' then Sales2
when variable ='S3' then Sales3
You may need to little bit tweak it to know the OnClick event on any of the Sales
If you like this approach pls mark ;)