Thanks for the solution but my data source is Sql server not excel.
Could you please tell me how to pivot the fields for sql server.
Here is one without the pivot using placeholders. which is quite difficult to manage.
I would suggest instead try custom query or view which would give you results like a pivot
e.g. select Trade, Col1 "Col" from Table
select Trade, Col2 "Col" from Table
or other pivoting techniques in sql server
Book1_v10.5.twbx 25.2 KB