hi,
I have a parameter toggling between Total $ and Total % with a need to show one value as $K and one value as %. Implemented showing properly formatted values in stack bars.
However now need to add reference lines for totals like displayed in the screen shot below for each selection showing proper formatting for $ and % depending upon parameter selection. Can someone help me understand how to do this? (reference lines should show $20,285K for Total $ option and 100% when Total % option is chosen)
Thank you,
Bhavana
Thank you so much Simon!!
Solution seems to be working mostly however there are a few details that seem to be missing. Looks like measures are put on detail shelf separately for putting together 2 separate reference lines. In that case, is there a way to change formatting mark label formatting? : e.g. in the following screenshot it should show mark labels in % format,
or if you choose Sales, it would show mark labels not just as numbers, but with $ sign?
thank you,
Bhavana
