Displaying Amount format in M￥

[#1]

Hi All,

I have a very unique requirement for a Japanese Customer.

Please find below is my requirement.

Normal Display:

2008 2009 2010

P1 ?750,000,000 ?852,006,452 ?250,005,698

P2 ?150,000 ?250,000,000 ?98,000,000

P3 ?25,000 ?259,000,000 ?108,000,000

Now I want the above display in the Pivot table as follows:

2008 2009 2010

P1 M?750 M?852 M?250

P2 M?1.5 M?250 M?98

P3 T?25 M?259 M?108

M? -- To Display Million Data

T? -- To Display Thousand Data

B? -- To Display Billion Data

Is this possible in Qlikview?

Please help me...