Get the value in expression

[vipin_mishra479]

here i have attached the application and excel file.

I have a Amount by customer

like

Customer , Amount

A ,111

B , 222

C , 333

and here i have create one inline table where i define Group and Stregity

like

Group,Stregity

111,New

222,Middle

333,Old

So final result i want is

Customer  Amount  Stregity

    A             111       New

    B              222      Middle

    C             333       Old

[miguelbraga]

hey there,

Have you tried to use map table like this?

Map:

MAPPING LOAD * INLINE [

    Amount, Stregity

    111, New

    222, Middel

    333, Old

    121, Avg

    221, Check

    332, Done

];

And then use this:

LOAD Customer,

     Region,

     Applymap('Map', Amount) as Stregity,

     Amount

FROM

(ooxml, embedded labels, table is Sheet1);

This is by far the best answer for your problems, because, not only you automacally drop the Inline table but also join your correspondent value to your table .

Hope this solve your issue once and for all

Regards,

MB

[varshavig12]

@

[varshavig12]

Exactly!

[chetansehgal]

Try this in the calculated dimension of you chart

For Customer Dimension

if(Amount=Group,Customer)

For Group Dimension

if(Amount=Group,Group)

Third Dimension:Stregity

Expression = 1

and hide the expression

[vipin_mishra479]

Thanks for reply guys i don't know if i am not able to explain you or what

Actually this is just a example so that i give this way

but actually the Amount part i am getting in front end so that user give the excell and tell if your amount are equal with this group so show the stargity of that.

[chetansehgal]

also suppress the null values in all the dimensions.

[varshavig12]

Something like:

if Amount = Group then stargity

[vipin_mishra479]

nop its not working i'll try this

[varshavig12]

Okay!

Last try:

do you want this :

[vipin_mishra479]

thanks for the help but i need Amount also