1 Reply Latest reply: Nov 22, 2012 11:32 AM by Srini VEERAVALLI RSS

    Pivot table % of Total requirement

    945516
      I have one requirement.

      I have one report which shows top n states by Units along with % of Total (Total of all states irrespective of their rank) as follows

      state_code rank Units % of Total
      PA 1 300
      CL 2 200
      IL 3 100


      As here, we are showing top 3 states, Total=600 for these 3 states.

      I want to calculate % of Total not using Total=600, but using Total of all states irrespective of their rank.

      Please guide me on how to achieve it.

      I m using OBIEE 11g.

      Please let me know if u need more information.
        • 1. Re: Pivot table % of Total requirement
          Srini VEERAVALLI
          If the report is #units by product as if today then you can for another measure with level based by product(or any dim which you use in report) and that can use to calculate % with existing unit measure. If you want level basemeasute slice and dice with any other dim like time then you need to go with sum(units by product,year) and go for %.

          If helps pls mark