Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Unpivoting regular column,calculated column and calculated measure in one table

Hello All,

I have a set of data as below:-

I do some calculations over this and end up with below set of data :-

Where in OVRCOUNT1,OVRCOUNT2,OVRGOOD1,OVRGOOD2 are all calculated columns.

Furthermore I create calculated measure as below:-

Where in COUNTPCT and GOODPCT are calculated measure.

I want to unpivot all these fields into one :-

 

I know this is a kind of unpivoting work but I am not sure how it can be done among regular columns, calculated columns and calculated measure altogether.

Can someone help me with this, it would be a great help to me!

 

Thank You in Advance!