After unpivoting the selected column, the column total is displaying a different value

[Anonymous]

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.

[Anonymous]

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.