Funnel Chart Expression Problem

[Anil_Babu_Samineni]

Hello,

PFA.

I have one excel which is 2014 Data. Now, i want to split three parts.

1) Whoever more than 70

2) In between of 50 & 70

3) Below 50

Can you please help me This...

[Anil_Babu_Samineni]

Where i need to copy this. In the expression / Dim

[MK_QSL]

Expression Background Color...

But you need to change according to your dimension names..
The answer I have given is based on your first attachment. For your 2nd qvw, you need some changes according to your fieldnames.

[Anil_Babu_Samineni]

Manish,

Thanks for your quick response, can you please work on welcome.qvw which i share the recent. Meantime, Please have a look of raw data. And then share me that qvw, Please?

Thanks

[MK_QSL]

attached

[Anil_Babu_Samineni]

I want to show Calculated Dimension like, Your first expression reply

[Anil_Babu_Samineni]

Manish,

Sorry for troubling. Just now i got the mail from Client.

They want to use as Dimension is - rep

Can you please help me now?

[Anil_Babu_Samineni]

Manish,

Last question, Is there any chance to put the Y-Axis from 0 to 100

- Anil

[MK_QSL]

No axis settings in funnel chart..

[Anil_Babu_Samineni]

Ok Manish,

Thanks.

Here, i want to show score into %.

How do we achieve this?