Compare the expression values of a single column after pivoting

[#1]

Hi All,

Here is my sample data

Col1	Col2	Col3	Col4
A	Q1	A1	AP1
A	Q1	A2	AP2
A	Q1	B1	BP1
A	Q1	B2	BP2
A	Q1	C1	CP1
B	Q1	A2	AP2
B	Q1	B1	BP1
B	Q1	D2	CP1

And , This is the output that i am looking for

Note:

1. Col1 is pivoted.

2. Expression used = Maxstring(Col4)

Any help is appreciated.

Thanks In Advance.

Message was edited by: Ravi Kumar

Message was edited by: Ravi Kumar

[veidlburkhard]

Where is the attachment?

[#3]

It is there right. I am able to see Comm_1 is the file name.

[qliksus]

Check the attachment

If you looked at the result the coloring is not done for all those values where the first values are Blank so assigning some values to the blank made the dimension values to be considered and it has shown the coloring for al the values

[#5 · Accepted solution]

Hi,

Yeah I did this by un-checking the Suppress zero values option and it is working fine.

Any way thanks for the response.