hi Everyone, above figure is my pivot table and I'm using match to get the order as i want but whenever I'm selecting the field ,the selected field comes at the top

[#1]

HEADER
K1	12	23	34
L1	14	26	65
C1	33	33	53
D1	32	98	67
E1	23	54	66

hi Everyone,

above figure is my pivot table and  I'm using match to get the order as i want

but whenever I'm selecting the field ,the selected field comes at the top ,suppose i select C1 then

Header 1	Header 2	Header 3	Header 4	Header 5
C1
K1
L1
D1
E1

I want to select C1 without disturbing its order,how can i do this?

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling.

[lironbaram]

in your match function use set analysis

[#4]

Can you please explain how can i do so?