Forum Discussion

Jones's avatar
Jones
New Contributor III
2 years ago

BIViewer Pivot - Grand Total filtering

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?

 

BI Viewer
Dashboards
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    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.