1) Create a Parameter on "Customer Name".
2) Then create a calculated field as like below,
Name: Showing sales for Selected Customer
Syntax: if [Customer_Field] = [Customer_Parameter] then [Sales] end
3) now you can place all required Dimensions & Measures onto view.
4) right click on "Parameter" on the parameter window, then click on "Show Parameter Control".
5) Then drag the above calculated field onto Labels.
No comments :
Post a Comment