How to navigate from summary report to the dynamical detail report?
In summary report, it contains region,south,quantity,sales1,sales2,sales3 columns,
when customers click sales1, it will navigate to detail report like:
when customers click sales2, it will navigate to detail report like:
when customers click sales3, it will navigate to detail report like:
I do not want to create three detail report, is it possible to judge the dynamical columns(Sales1,Sales2,Sales3) in detail report?
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
I am using the BI Content Navigation function, you said you can use variable in column, so I wan to know how to set the variable in measure for judging.
If it is ok, how to get the click event in reports? Thanks very much...