How to create a ranking pivot table with requirement as such.

[jim_chan]

Hi guys,

I have a problem here. This is a survey rank comparison chart.

Scenario:

When customer wants to click on the code - 12456. All codes that has same number "12(1st-2 numbers)" and "46(last 5th-6) numbers to be hlighlighted as well.

I do not know how to achieve this. I have attached a sample qvw file here.  Please help.!

Rgds

Jim

[Anonymous]

Is this ok for you?

I used alternate state.

Let me know.

[antoniotiman · Accepted solution]

Hi Jim,

see attachment

Regards,

Antonio