Can BI Publisher calculate 2 rows in a Pivot Table
Hi All,
Would like to know if it is feasible to only calculate 2 rows in a Pivot Table. For example i have 3 rows with the following amounts:
Row 1 = $300, Row2 = $100, Row3 = $500
I only want to calculate Row2 and Row3 and assign it to a name Row4. Expected result for the pivot table will be
Row 1 = $300, Row2 = $100, Row3 = $500, Row4 = $600.
Is the scenario above feasible in a BI publisher template?
Thanks!