Pivot table subtotal custom calculations

Manoj Dixit

That's fine. I am waiting for an update from the OP.

Manoj Dixit

With a change to the view, that is, instead of a Pivot - a table view, I could achieve as per a screen dump above.

Group Output = (Sum(Revenue for Year) * Sum(Billed Quantity for Year)) / Sum(Revenue for Year)

Row Output = (Revenue * Billed Quantity) / Sum(Billed Quantity for Year)

A Static Text view explains what the Group Output column values mean. I would try my best to convince the user that due to limitations this could be an option. The values are displayed on the last row per year (similar to 'After' functionality). They could be displayed on the first row (similar to 'Before' functionality).

Edit: Second column has Order Status to check that the group level calculation changes as per the varying row counts per Year values.

Manoj Dixit

Here is a Pivot Table view albiet with a bit different layout. Associated Table view is for verifying the Pivot Table view output.

Hope this helps.

cesar.advincula.o

Hello,

Recentlety, I could deal with something like thease in wich SUBTOTAL has a particular calculation, OBIEE make the SUBTOTAL or Total Based on the "Aggretation Rule" that you are using, however, return to your question,what I did it was to create an UNION reports and with the second one I created the SUBTOTAL ROWS that we have to use, lets order by your Column and apply the format that you have to use.

Kind Regards.

Manoj Dixit

Hi,

Right now it's Friday evening so not in front of a computer. But I can fairly guess what you are trying to say.

However, as previously mentioned by Thomas Dodds, those two are different measurements as the calculations are different. Personally, I would keep them separated so that it's less confusing to the users.

Have a great weekend.

Regards,

Manoj.