BIViewer Pivot - Grand Total filtering

[Jones]

Hey,

We have a Pivot in the BI viewer with 3 rows say Row 1,Row 2,Row 3 and we want the sum of Row 1 and Row 2 as Grand total. Today when we try to do this, we get the sum off all 3 Rows.

Is it possible to archive this in BI Viewer?

[JackLacava]

Not tested, but it should be doable to define a Calculated Field that will include only values that would appear in the first two rows, call it "Grand Total" or whatever, and assign it to the component.