Focal Point
Excluding data series from stack total [SOLVED]

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9287013926

March 08, 2013, 10:52 AM
WebFocus User 52
Excluding data series from stack total [SOLVED]
I have a stacked chart that reports 4 data series. I want to show a stacked total that includes Only two series (i.e. series(0) + series(1) ) and exclued series(2) and (3).

Does anyone know how to do this?

is there a way setdisplaygetDataTextStackedTotalOnTop(),true) could be edited to achieve this.

This message has been edited. Last edited by: WebFocus User 52,


WebFOCUS 7.6
Windows, All Outputs
March 21, 2013, 04:47 PM
Doug
Confused Remove those two series from your SUM (in your fex) should do the trick...
March 27, 2013, 04:22 PM
WebFocus User 52
Well, I still want to have them displayed on the chart. I thought I could do a PRINT and SUM simultenously, but Can't.


WebFOCUS 7.6
Windows, All Outputs
March 28, 2013, 08:29 AM
FrankDutch
Create an extra field with the sum on field1 and field2
It will be on top of the others
Give it a color white, so it is invisible
Then you can display only this series
And maybe this value better could be used in a line instead of an stacked bar




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

March 28, 2013, 10:26 AM
WebFocus User 52
Thank you very much Frank. This Works Perfectly. I created a new field adding the numbers I wanted to display their total. I used a line and set it up as an independent, transparent data series.


WebFOCUS 7.6
Windows, All Outputs