Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Pivot\Unpivot

I have table with a few columns, I filter to specific Order for the purpose of the example,  I want to show 1 row for all orders that all type paper get his QTY . sometimes I have 3/4/5... ty...
Need Help
  • mussaenda's avatar
    mussaenda
    2 years ago

    Hi Anonymous ,

     

     

    This might not be the most elegant way to achieve what you need. But have a check on this for the idea

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi , 
I want to display for every order 1 row .
From source table (photo 1) I want to get :

Thank you