Product: TIBCO Spotfire®
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