Forum Discussion

vijayghatti's avatar
vijayghatti
Frequent Visitor
9 years ago

Data Transpose

  Hello friends,   can you please help me on how to translate the data shown below   Project                     Area1                     Area2                 Area3   P100                   ...
Need Help
vijayghatti's avatar
vijayghatti
Frequent Visitor
9 years ago

Thank you for the help.

 

i was able to do the things as per the steps explained, how ever let me try to explain the senario.

 

i have a view which has the metadata that is required for the report and a table which has the list of projects, both are from SQL server.

now i imported the data and followed the steps as said, but i am not able to show the output in the way that was desired to be.

 

.

 

screenshot 3 is the expected format and also i need to show the percentage of values in another column.

hope this clarifies.

 

thanks

Vijay

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi vijayghatti,

 

So, image1 is what you get after "Unpivot" table, right? Now, you want to create a visual displayinglike image3 based on image1 table, right?

 

Would you please elaborate the structre of your desired output, having row group/column group, or hierarchy? And how do you want to calculate the percentage value?

 

Regards,
Yuliana Gu