Forum Discussion
Solved
Pull Row Values to Specific Columns
Hello, I have been trying to find a solution for a table I have been working on. I have multiple columns, but each column only needs one row of data per date. I need to keep the column nam...
Thank you for the feedback and tips to try. How I resolved it was I unpivoted the metrics columns, merged the metrics with the attributes, pivoted again and removed the columns not required.
Celine2022 , Not very clear. You should use slicer/filter in the report
Hello, Thank you for the response. I tried that in the visualisation but I still need to create measures out of the values that I need to get into the columns so I am unable to do that as multiple attributes appear under the one metric so I was hoping to reduce to the one value I need to use to create measure required for the reports.