BI Publisher Pivot Tables

At design time, we don’t always know how many rows and columns a table will have, nor what their labels will be. Pivot Tables place a grid on a BI Publisher report that is data dependent.
BI Publisher Pivot Table Documentation
BI Publisher Templates: docs.oracle.com/middleware/12...
RTF Pivot Grids: docs.oracle.com/middleware/12...
Jump to specific sections:
00:00 Intro
00:25 Why Pivot Tables
02:07 Documentation Links
02:26 Where to get the demo objects
02:41 Basic Walk Through
07:48 Sub Categories
10:25 Totals and Subtotals
11:35 Grouping issue fix - Structured data
14:14 Grouping issue fix - Unnstructured data
14:25 Bi Pivot Tables in PeopleSoft
PeopleTools Tech Tips: peopletoolstechtips.com/bi-pu...
Github: github.com/PeopleToolsTechTip...
Production Notes:
A PT3 Production
Presenter: Randall Groncki
Camera Kid: Anjelica Groncki
Music: Vlad Gluschenko - Overseas
License: CC BY 3.0: creativecommons.org/licenses/...
/ @vladgluschenkomusic

[@fabryddorf]

Great Video Sir! Is there a way to have measure labels appear as rows? I did not find anything in this regards. Let's say on columns you have market codes, for each market codes you have a bunch of measures. On the rows i would like to shows : Number of rooms, number of guests, room revenue, food revenue, total revenue. For each market code i would like to see these values

[@PeopleToolsTechTips]

Unfortunately, I'm not sure that BI Pub can work with that multi-dimension data in a pivot grid. You would be working with multiple numbers in the grid representing different items that you would not want analyzed together. Ie: you wouldn't want to sum rooms and guests together.
It would be fun to try. You would have your market as a key, and the rooms, guests and different revenues as different fields in that data row. Then drag all those data rows into the grid.

[@eylinevonnyonateorozco3343]

Can I have in the pivot table a total field with the rows average instaead of sum?

[@PeopleToolsTechTips]

Unfortunately, the aggregations are only SUM and COUNT.
Not Average

[@kdavis5450]

Can you do a pivot table in BI Publisher rtf template without aggregation? In Excel, I can choose Max value instead of couting or summing I have several Six categories that each represent a set time frame (Ex. Summer2, Fall, Winter, Spring, Summer1), There are several groups and within each group for each timeframe, there are several item codes. Each of those items could cost a flat amount or an amount per unit. I want a pivot table showing the items down the left with the timeframes across the top. In the section that would normally be aggregated, I want the exact amount associated with the item code. Can this be done in BI Publisher?

[@PeopleToolsTechTips]

I've been thinking about this one. The best idea I can think of is to pre-massage your data so that only one entry per category is found for the pivot table and use summation (not count).