Formatting Table Headers

[#1]

All,

I would like to know if there is a way to create a table header in the below format.

Total X		Total Y		TotalZ
X1	x2	y1	y2	Z1	Z2

I need a have two columns insider a single column. I believe it can be done using pivote tables but once I have the table, I need to sort the table based on field which is not going to be in the table.

I could make the sorting with the "Table Box" but I not sure it will be possible using "Pivot Table"

Any suggestions pls.

[Gysbert_Wassenaar]

You can use text boxes and place those over the headers. Or for a pivot table you can first create an extra table with a field for the totals labels:

Field A, Field B

Total X, X1

Total X, X2

Total Y, Y1

Total Y, Y2

Total Z, Z1

Total Z, Z2

You can the add the new Field A as a dimension in the pivot table and put it above Field B.

That obviously won't work if X1, X2, Y2 ... etc are not values from a field (named Field B in this example), but expressions.

[#3]

Gysbert,

Thanks for your suggestions. I think adding text boxes would be a simple but effective solution for me in this case. But I will try both.