This is actually an old issue, I am not sure if I have posted before.
The table looks like this:
Product Sales Amt Forecast Amt Sales Target Amt Sales Qty Forecast Qty Target Qty
Product A 11 12 13 14 15 16
Product B 21 22 23 24 25 26
Using Report Studio, I want a crosstab that looks like this:
Sales Forecast Target
Product A Amt 11 12 13
Qty 14 15 16
Product B Amt 21 22 23
Qty 24 25 26
Any ideas how to achieve efficiently?
Hi - it wouldn't be a crosstab as such, but you can probably get something like this by unlocking your list then adding a table into the second cell (after the Product) that's 4 columns by 3 rows (to allow for the headings). Then you should be able to move the fields into the relevant fields...worth a try anyway