3 dimension

Anonymous — Tue, 04 Aug 2015 03:00:22 GMT

Hi,

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

require your suggestions

Re: re-size of 3rd dimension

jagan — Wed, 05 Aug 2015 09:02:47 GMT

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.