Forum Discussion
dscheid
7 years agoFrequent Visitor
Pivot / Matrix Data Reorganization
I want to pivot my data so that I can compare two identities side by side. Currently, the data for both entities is listed in one row, because their relationship is important to know. Here is an example of the formatting currently.
This is how I want the visualization to look in the final report:
I plan on using the Smart Filter by OKVIZ to search for a specific ID. Any thoughts on how I could do this?
dscheid here is something I did put together for you with sample data, you can take it from there.
Mainly power query takes care of big chunk of work.