BI Publisher (MOSC)

MOSC Banner

Pivot Table - Subtotals for C1 and C2

edited May 29, 2014 12:00PM in BI Publisher (MOSC) 1 commentAnswered

Hello,

I have a Pivot Table where I am looking to have totals for both C1 and C2 on the table. I have inserted an expression below the quarterly totals for each vendor but it is giving the total for the year including all vendors. I am looking to have each yearly total seperate for each vendor.

I am able to group this information by C1 (which shows the total Yearly spend for all vendors in the cell) and also have formatting to spread the columns out to the 4 quarters. I run into an error when I try grouping this data by R1C1 to give me the desired results of seperating the yearly total by vendor name and including the expression to size the cell to cover 4 columns. I am able to get the correct numbers when I exclude the formatting expression (NC) but it does not align correctly.

Tagged:

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