Formatting of measures based on a particular scenario
734923Dec 3 2009 — edited Dec 3 2009
I have created a pivot report on which measures are on side labels (rows) and scenarios (having values Actual, Budget, Var, Var%, LTD Actual, LTD Budget, LTD Var, LTD Var%) in columns.
Rest dimension members are excluded from pivot and managed by dashboard prompts.
Var, Var%, LTD Var and LTD Var% are computed items on pivot based on scenario column.
Report is working fine but i am facing problem in adding currency symbol ($) as prefix with values of Actual, Budget, Var, LTD Actual, LTD Budget, LTD Var and '%' as a suffix with values of Var% and LTD Var%.
How can i do different formatting of the same measure according to different scenario values.
Thanks in advance.