Need to add a total valuation column to a crosstab 1

[JeffMachine]

I have created a crosstab report that shows each item and the quantity of that item in each warehouse along with the total of all warehouses.

whse1 whse2 whse3 total
item1 1 2 6 9
item2 0 3 2 5

I would like to add the item's description as a column and a total valuation (total*unitcost) column for each item.

whse1 whse2 whse3 total Valuation
item1 description1 1 2 6 9 18
item2 description2 0 3 2 5 50

I'm having a problem getting from the first example to the second. I can create a formula that concactenates the item and description for the row group but it's a little uglier than if the description had its own column. I also can't figure out how to get the valuation on the the crosstab.

I have version XI.

Thanks ....

 

[lbass]

Add the description as the second row field and in the customize style tab, select it and check "suppress subtotal". You need to add the formula total*unitcost as a second summary field and in the customize style tab, choose "horizontal summaries". You can suppress it and its label in the inner cells, and then grab the border of the inner cell to make it as narrow as possible (easier in design mode). It should become so narrow that it is not obvious in preview mode. The total column will then show the desired result.

-LB

 

[JeffMachine]

Thanks lbass, that worked for me.