1 Reply Latest reply on Nov 22, 2012 5:32 PM by SriniVEERAVALLI

# Pivot table % of Total requirement

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
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
1 person found this helpful