Forum Discussion
After unpivoting the selected column, the column total is displaying a different value
After unpivoting the selected column, the column total is displaying a different value instead of the original value. I have attached sample Data link Data link .
in this sheet i have following column Total 2023 RF6, Total 2024 OB .
Total 2024 OB total value - 13,27,127
Total 2023 RF6 total value - 14,47,226
After unpivoting the selected columns, the total displayed for each column appears to be different from the original values. I am seeking assistance to resolve this discrepancy. Any help would be greatly appreciated. Thank you in advance.
1 Reply
Hi Anonymous ,
Can you show how you did the unpivot, preferably using screenshots of the results from selecting the column to the unpivot to the result after the unpivot?
I don't know how you are proceeding on text alone.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.