BI Publisher (MOSC)

MOSC Banner

BI Publisher - Quarterly and Annual Totals in Same Pivot Table for Multiple Years?

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

I have a BI Publisher pivot table put together shows the vendor spend for each quarter (example below). The data source has a field that converts the Accounting date to a Quarter format (To_char(accounting_dt,'yyyy-Q'). The Columns are grouped by the Quarter Field and the Rows are grouped by vendor name with Monetary Value as the table value. Currently the Pivot Table gives a total for each quarter across the table and then a grand total at the end. I am looking to keep the quarterly totals in tact but add an additional column after each 4 quarters to give an

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