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 pos...
Forum Discussion
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.