Skip to Content
0
Former Member
Jan 01, 2014 at 06:50 AM

Showing data in 'Ones' , 'Thousands' & 'Millions'

1077 Views

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