The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Jones's avatar
Jones
Contributor
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

1 Reply

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    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.