Pivot Table Expression

[#1]

Hi, I have attached the scenario which i want to try doing in Qlikview.

Is this possible in qlikview?

Am getting the chart as in sheet named current output.

Can some one explain me how to get the result as in sheet Expected Result.

Message was edited by: Abirami Rajendran I have added a sample data in the Data.xlsx in Raw Data Tab.

[#2]

Can someone help me out on this..

[mightyqlikers]

hi sagar,

could you please create sample data in excel and post.    

[pamaxeed]

Please as sam mentioned to help you, you should provide us sample data...

Regards,

Patric

[#5]

Please find the attachment of my post.. I have provided the sample data...

[mightyqlikers]

not that sagar,

actual data in excel format.    

[#7]

I have added a part of the data in the Raw Data tab in my post now.

[#8]

The raw data is added in data.xlsx file now.

[pamaxeed]

Hope this helps, see attached.

Cheers,

Patric