BI Publisher (MOSC)

MOSC Banner

Can BI Publisher calculate 2 rows in a Pivot Table

edited Nov 16, 2020 3:45PM in BI Publisher (MOSC) 2 commentsAnswered

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!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center