Dear BPC Experts,
I am designing a report in BPC 10 NW and in this client want the choice of showing the revenue number in 'Ones', ' Thousands' & 'Millions'.
I tried conditonal formatting and created three ruls for one, thousand and million. But this approach only accept one rule.
Kindly advice if there is any EPM function to meet this requiremtnt OR how can I create a drop down with three option (i.e Ones, Thousands. & Million) and client select anyone and refresh the report and the data format is changed accourdingly.
Kind Regards,
Nisha