Forum Discussion
Create Pivot table
Dear members
I have source table which I would like to turn in pivot table. Since my source table is formed from different table columns I cant use simple pivot function.
Matrix view is not a choise also, since I need to use 1st level measure, 2nd level measure etc. separately.
I need to create this desired table as a new table.
Please help me with this issue.
hi, OSS
Do mean that the three columns are from different table and you haven't put them into one table like this:
If so you need to put them into one table, use Merge queries function in edit query to merge basic tables and then remove the other columns to get a table that contains these three columns.
then pivot the table as below:
Select Origin column click Transform -> Pivot column
Result:
Best Regards,
Lin
3 Replies
hi, OSS
Do mean that the three columns are from different table and you haven't put them into one table like this:
If so you need to put them into one table, use Merge queries function in edit query to merge basic tables and then remove the other columns to get a table that contains these three columns.
then pivot the table as below:
Select Origin column click Transform -> Pivot column
Result:
Best Regards,
Lin
v-lili6-msft Thank you very much. This is exactly what I was looking for.
v-lili6-msft wrote:hi, OSS
Do mean that the three columns are from different table and you haven't put them into one table like this:
If so you need to put them into one table, use Merge queries function in edit query to merge basic tables and then remove the other columns to get a table that contains these three columns.
then pivot the table as below:
Select Origin column click Transform -> Pivot column
Result:
Best Regards,
Lin
How do I do this for a table with more than one column?
I have a table like this.
Month - Year Tot Avail Rented Vacated Net 12/1/2018 719955 31521 30450 1071 11/1/2018 707765 31244 31216 28 10/1/2018 728607 34848 34184 664 9/1/2018 713773 35320 35248 72 8/1/2018 695455 38134 43183 -5049 7/1/2018 687525 40915 33624 7291 I want it to look like this.
Month - Year 12/1/2018 11/1/2018 10/1/2018 9/1/2018 8/1/2018 7/1/2018 Tot Avail 719955 707765 728607 713773 695455 687525 Rented 31521 31244 34848 35320 38134 40915 Vacated 30450 31216 34184 35248 43183 33624 Net 1071 28 664 72 -5049 7291
