Forum Discussion
Pivoting
Hi, I am in need of converting the data from rows to columns. Example is provided below. Not too sure pivoting feature will help achieve this but my efforts with it weren't fruitful. Appreciate your ...
I actually want to plot this data on a matrix visual, Account Name on Rows; Years on column and Sales (plus many more fields) on the values. I have a measure, which I will put on values for the Year.
Something like this (I didn't try to refer the data I used in my initial thread for this post, sorry):
| Account Name | 2016 | 2017 | 2018 | 2019 | Sales | Revenue |
| Account 1 | Y | Y | 4569 | 4359 | ||
| Account 2 | Y | Y | 34533 | 35434 | ||
| Account 3 | Y | Y | Y | 43856 | 54646 |
I am not sure how to do this mix and match i.e. some fields going on columns well and some on values well. Maybe there is a custom visual, which does this kind of report.
Thanks again for your prompt help.
-SN
Hi,
I am sorry but i really cannot understand your desired output structure. Someone else will help you.