Non-typical structure of data in the pivot table, how to?

[Prosperitas]

Hello, please help!

1) I have the table with columns:
- Buyer
- Country
- Product
- Revenue
- Quantity
- Actual vs. Forecast (Yes/No)

2) The problem is I can not structure the data in pivot table properly. I need:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Actual[/TD]
[TD]Forecast[/TD]
[TD]Delta[/TD]
[/TR]
[TR]
[TD]Buyer A[/TD]
[TD]Revenue[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]Buyer A[/TD]
[TD]Quantity[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]Buyer A[/TD]
[TD]Price[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
</tbody>[/TABLE]
Ideally Buyer A cells should be merged.

I did everything else except this problem. I have:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Revenue (actual)[/TD]
[TD]Revenue (forecast)[/TD]
[TD]Delta[/TD]
[TD]Quantity (actual)[/TD]
[TD]Quantity (forecast)[/TD]
[TD]Delta[/TD]
[TD]Price (actual)[/TD]
[TD]Price (forecast)[/TD]
[TD]Delta[/TD]
[/TR]
[TR]
[TD]Buyer A[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
</tbody>[/TABLE]

3) I do have some experience with Powerpivot, DAX and VBA. I am not a native speaker. Thank you in advance.

 

[Scott Huish]

Duplicate post. See http://www.mrexcel.com/forum/powerp...n-typical-structure-data-pivot-table-how.html