Table help

[#1]

Hi guys! I need help creating a qlik table/chart. I'm currently getting this in my output:

But what I want to see is :

Is it possible to get this view in Qlik?

[Nicole-Smith]

Use a pivot table and make sure pivoting is enabled (presentation tab).  You should be able to drag your columns and rows to get the view that you want (and you'll need to add project as a dimension).

[#3]

I double checked that Pivoting is enabled but its not letting me drag the plan Year/Month to a row. Any suggestion?

[#4]

Update: Finally got it working. How can I tell the table to only display the value in this table if Qty>0?

[sunny_talwar]

Yes, Pivot table is the way to go as Nicole‌ suggested. But how exactly will it work is difficult to suggest without looking at the data structure and the expressions. Would you be able to provide a sample?

[sunny_talwar]

You can check the option to 'Suppress Zero Values' on the presentation tab

[#7]

Thank you for your response. I now have the pivot table layout fixed but it still is not Suppressing Zero Values even though the option has been selected. What could I be doing wrong?

[sunny_talwar]

Would you be able to share a snapshot of what you are seeing?