Thank you SSC Veteran! I wrote a Stored procedure to get the columns I need in a table and that worked out! Have used the SP table data to get...

I have a report as input which should be modified , there is no unpivoted data.

Hi Thom,

Thanks for your reply!

But my question is not averaging on a single column, if I understand it correct,

The data in report is something like this

IDSeller HyderabadBangalore

1Nikhil...