Forum Discussion
Pivoting Columns
I am trying to pivot 12 coloumns into two coloumns of Actual value and Target value. The thing is it is pivoted in two different raws, having 12 raws of actual then 12 raws of target. and it is annoying since I cant benifit from them being in the same raw to do comparisons. Here is the photo.
Please help me it is super important. I already do with th pivoting the "Don't aggregate" option.
Thanks in advance.
2 Replies
can you share the intial structure of your table with some dummy data.
that would be helpful
best regards
Hello,
It is like this but much bigger, I first unpivot the months colouns then pivot the target actual so I have the coloumn of Months then Target Then actual. But then the Target and actual are separated in different coloumns like my first photo in the original post.
Thanks a lot
Source.Name.1 KPI code Year to day average. Target-Actual January February March April May June July August September October November December Plant 1 L9 5 Target 5 5 5 5 5 5 5 5 5 5 5 5 Plant 1 L9 3 Actual 3 3 3 3 3 3 3 3 3 3 3 3 Plant 2 L9 156787 Target 14150 12757 14497 14389 14400 13755 14446 6033 14313 13679 14290 10078 Plant 2 L9 null Actual 14106,8 14220 15221,5 13816 15371 13034 13796,25 6348 13369,5 14292 0 0
