Forum Discussion

AndrejZitnay's avatar
AndrejZitnay
Post Patron
9 years ago
Solved

Transpose table with weighted average

Hello Guys,   Can you please help me with transposing table? I need to create P&L per specific category. My problem is that Category is in rows but I need that in columns. Please be aware that c...
Need Help
  • Baskar's avatar
    Baskar
    9 years ago

    Hi,

     

    I tried but i can't any way to get table like which u mention in above.

     

    but i suggested to u, y  u go with like this model. it will also help to u reach your goal.

     

    pls look these images , and let me know if any help.

    Select four column and click Unpivot

     

     

    Now this is your Table

     

     

    This is Matrix Report

     

     

     

     

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Hi,

 

I tried but i can't any way to get table like which u mention in above.

 

but i suggested to u, y  u go with like this model. it will also help to u reach your goal.

 

pls look these images , and let me know if any help.

Select four column and click Unpivot

 

 

Now this is your Table

 

 

This is Matrix Report

 

 

 

 

  • AndrejZitnay's avatar
    AndrejZitnay
    Post Patron
    9 years ago

    Hello Baskar. Thank you for your sugestion. I will look at this once I will be back from my holiday.