Hi All,
i have problem . i created parameter with profit and sales in drop down but i am not getting how to do this any help will be highly appreciated.
Ex : if i select profit pie must chow profit wise values etc..
7 answers
Hi Jessy
Step:1Create parameter [Measure Parameter] list as Sales, Profit and Unit Price
Step:2Create calculation as follows [Measure Calc]
case [Measure Parameter]
when "Sales" then [Sales]
when "Profit" then [Profit]
when "Unit Price" then [Unit Price]
end
Step:3Select product category and new calc and select show me pie chart.
Step:4Show Parameter control and select Kpis.
Now you will get relevant one.
Thanks
sankar