I have a Crosstab that I have gone as far as I can tell toward the goal; and I would appreciate your experience if you have solved one of these two problems.
#1 On a crosstab the requirement is that I have additional calculated columns in the Grand Total Column based on the totals. Such as the profit below which would be Sales X Profit% = $210,000 X 0.60 = 12.60.
Product Sale Price Profit Jan Feb Mar… Nov Dec Profit Total
Cardinals Tickets [ 6.0%] 50,000 66,000 77,000 15,000 2,000 [12,600] 210,000
Cardinal Ball Caps [2.0%] 2,000 8,000 18,000 9,000 3,000 [800] 40,000
#2 The profit figure printed in the end of the row title. I had this worked out at one point and have lost it since.