Forum Discussion
Split into rows
Hi All, I have a question on the split a column into rows. But when i perfor that action the total value would get affected. is there any possibilty to keep the total same and have the individua...
RanjanThammaiah Please follow below steps
Go to edit query and split the columns by , delimiter
then select the value column and select unpivot other columns option.
If it helps acept as solution.
Anonymous a quick tip; when you select Advanced options in the split columns by delimiter window, you can select split by rows. This saves a step for pivotting your table!
Not sure if i am clear on my request.
When i do the delimiter the values are repeting with ech other and i am getting the dashboard number affected.
Regards,
Ranjan
