How to show top three values in text chart

[varma8998]

Hi Team,

I want to show the top three region values in the Text Chart

i am unable to attach the sample format that's the reason i am typing the table in the below format

The Columns are:

Curreny | Scenario | Proj Year | Region | CODE | Amount

The Below are the Values to the respective columns:

Dynamic | Scenario1 | Year 1 | Canada | 12345

Dynamic | Scenario 2 | Year 2 | France | 56789

Dynamic | Scenario 3 | Year 3 | Germany | 112233

so on……... 

Constant | Scenario 1 | Year 1 | Canada |12345

Constant | Scenario 2 | Year 2 | France | 56789

Constant | Scenario 3 | Year 3 | Germany | 112233

so on...………...   

now i want to show the top three region values based upon these columns

((Sum({<CURRENCY = {"Constant"}, SCENARIO = {"SCENARIO1"}, CODE = {"12345"}, YEAR = {"Y1","Y2","Y3"}}AMOUNT)
-
Sum({<CURRENCY = {"Constant"}, SCENARIO = {"SCENARIO2"}, COA_CODE = {"56789"},YEAR = {"Y1","Y2","Y3"}>}C_AMOUNT))/1000000)

[Ezirraffner]

Is it? In side properties of the dimension.

[varma8998]

Hi Ezir,

I am unable to see in the text chart

[Ezirraffner]

@varma8998 

Can you take a print screen of the text chart?