Skip to main content
J
Jones
August 30, 2023

BIViewer Pivot - Grand Total filtering

  • August 30, 2023
  • 1 reply
  • 0 views

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?

JonesHedlund_0-1693399480932.png

 

1 reply

J
JackLacava
August 30, 2023

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.

Terms & ConditionsAccessibility statement