3 dimension

[Anonymous]

Hi,

I have  a chart with filter selections. attached is the sample app n data source.

require your suggestions

[jagan]

Hi,

Change your script like below

Country:

LOAD

*,

if(  Index([IPG_KRANGE],'-')<1,1,

  num(PurgeChar( mid([IPG_KRANGE], Index([IPG_KRANGE],'-') +1),'K'))

) AS IPG_VALUE;

LOAD Name,

     Country,

     IPGK,

     //IPGKRANGE,

     if(IPGKRANGE ='-',Dual('-',1),

     if(IPGKRANGE = 'Less than 1K',Dual('Less than 1K',2),

     if(IPGKRANGE = '1.000-4.999K','1000-4999K',

     if(IPGKRANGE='5.000-9.999K','5000-9999K',

     if(IPGKRANGE='10.000-19.999K','10000-19999K',

     if(IPGKRANGE='20.000K or more','20000K or more',IPGKRANGE)))))) as IPG_KRANGE, 

     Modes,

     Latitude,

     Longitude,

     PSGK,

     PSGKRANGE,

     psgkrange,

     Zip_Code

FROM

(biff, embedded labels, table is Sheet1$);

Now use

=Max(IPG_VALUE)

as expression for IPG_KRANGE.

REgards,

Jagan.