8 Replies Latest reply on Jul 24, 2019 1:06 PM by 1060597

    Pivot table Sub Total for records within each Accounting Period.

    1060597

      I want to achieve Total column only for records with price mentioned above for each AP excluding columns with "WAC".

       

      Ex: For AP 01, I Want to have Total column Before "WAC", which totals values with prices 5.111 and 5.112 excluding values in "WAC".

       

      Please help me how to get this done in OBIEE 11g.

       

      Thanks

      Prabhu