Double values are coming when i go for Unpivot

[harib]

Hello Friends

When we unpivot the columns values are doubling . Can't we show the before unpivot value like 40  in unpivot table  instead of showing the 120. And do we get any performance issues with Unpivot data because of multiple values. Please let me know. For more understanding i have given pictures.

Before Unpivot

 

After Unpivot

Thanks in Advance if anyone give clarity on this.

[v-xicai]

Hi @harib ,

You need to show the 40 in place mark1 or in place mark2?  Could you please share your desired output screenshots for further analysis?

Best Regards,

Amy

[harib]

@v-xicai 

Thanks for you responce. Due to busy with someother work i didn't see your post. ActuallyI want to show 40 in place of Mark 2. If it's possible kindly give me the solution

Thanks in advance