BI Publisher (MOSC)

MOSC Banner

Crosstab Custom Calculation calculation in RTF template

edited Jan 13, 2014 6:29AM in BI Publisher (MOSC) 1 commentAnswered
 Hi,
  I am creating Pivot table by Using RTF template, I want do some extra calculation in the Aggregation Part.

  Code of My Pivot Table is show below:

   ?crosstab:c12918;"//G_1";"SUPPLIER_NAME{,o=a,t=t}";"BUSINESSMONTH{,o=a,t=t}";"QTY";"sum"?>

    The result of Pivot is :

                                        November October
     AUS Warehouse         26               10
      Local Grocery             0                 41   

Now, what I want to do custom calculation like this  Sum(Qty)/720*100 

I would be really grateful, if anyone advise me.
  
  

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