Forum Discussion
Help creating a chart
Hi all, I am seeking help on how to create a chart that shows employees that have worked in more than one agency. I think that the best way to represent it is by the number of links. I have an Excel ...
How do I attach a file? I see no option. I copied and pasted the table in my prvious reply but now it is gone from the thread.
Anonymous
Load your file to somewhere like Google Drive, OneDrive or Dropbox, then link to it from here.
Phil
Here is the link to the file on DropBox https://www.dropbox.com/scl/fi/9xt2gft4yggii4wk8m8x1/Transits-Across-EU-Agencies.xlsx?rlkey=fog1l2uopynglses69dvjldqf&dl=0
Anonymous
in PQ， select the agencies column and unpivot other columns.
then it will be easy to get the result
