Crosstab Total properties

[jmiller]

I have a crosstab where the summarized data is in columns. There is a total for each column at the bottom of the crosstab. Is there a way to define the properties for the individual column totals? For example for one column I do not want a total to appear. In another I want to add some text with the total. And in another maybe even do some conditional formatting.
P1 P2
C1 D1 D2 D3 D1 D2 D3
C2 D1 D2 D3 D1 D2 D3
----- ---- ---- ---- ---- ----
T1 T2 T3 T1 T2 T3

The total T1, I do not want to display. T3 I would like to be bold and red if the total is negative.

[Alex K.]

Hello,

Could you, please send us test data in the form you use them. We need them for analysis.

Thank you.

[jmiller]

Here you go. I would like it so that 1) the "Unit Price" column does not total and if the "Total Price" is below 750 then make the total bold and blue. I also would like to see an example of adding text to the total. For example in the "Total Price" total:
if ( total < 500 ) "Poor: "
else if ( total < 750 ) "Fair: "
else "Good: "
+ (the total)

So the totals for Bolts would be:
Unit Price: "empty"
Quantity: "750"
Total Cost: "Good: 937.50"

And the totals for Buts would be:
Unit Price: "empty"
Quantity: "750"
Total Cost: "Fair: 562.50" (and the text is blue)

[HighAley]

Hello.

Here you go. I would like it so that 1) the "Unit Price" column does not total and if the "Total Price" is below 750 then make the total bold and blue. I also would like to see an example of adding text to the total.

To switch off total in the "Unit Price" column, please, set the summary property to "None". See attached image.

Unfortunately, the condition for one of totals isn't supported now. You can set the condition formatting only for all Totals.

Thank you.