Skip to Content
0
Former Member
Oct 24, 2011 at 08:11 PM

CrossTab Puzzle

25 Views

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 Maru2026 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 percentage printed in the end of the row title. I had this worked out at one point and have lost it since.

vbwrangler