4 Replies Latest reply on Apr 14, 2015 6:58 AM by dileraco

OBIEE Percent Question

Hello everybody,

I want to calculate a percentage column but could not be successful Following image shows what I want to calculate. At the beginning of the analysis, total number of customer number exists. In measures, this value is grouped by month value and I want to find % value for these cols.

Each month divided value will be divided to total column value. How can I achieve such a percentage table?

Can you help me please. Regards,

Dilek

• 1. Re: OBIEE Percent Question

Hi,

Do the following:

1- go to the tab criteria;

2 - Add a new column. In its formula make the calculation that you want (metric / Qty Total customers) / 100;

3 - In the Column property above configure the appropriate mask (%) with the number of decimal places you want;

4 - Add this column in your pivot table.

Hope this help

Felipe Idalgo

• 2. Re: OBIEE Percent Question

No, this way is not suitable for me. Because ration/denominator values are same. Denominator is just totol value, ration is a grouped by value. When I create such a formula it gives me the result as: %100