How to get a net total in bar charts with negative values?

How to get a net total in bar charts with negative values?

When a stacked bar chart has both positive and negative values Spotfire shows each total separately when labels are displayed.  This article shows one way to get a net total. Users can take advantage of Trellis options in Spotfire to get a net total.  Use an expression similar to:

<[Division] & " - " & Integer(Sum([Value]) OVER ([Division]))>

as your Trellis custom expression, where [Division] is the column that groups your data into desired Trellis panels and [Value] is the column that comprises the bar. https://tibco.aha.io/ideas/ideas/SPF-I-5159