cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating percentages skipping few items in a report

Former Member
0 Kudos
28

Hello Gurus,

In my query Under rows I have a structure with following items:

trade sales

net sales

net income

op income

In my columns I have entities america, china, europe

My report is as below:

America China Europe

trade sales 40 35 45

net sales 40 37 50

net income 10 8 15

op income 12 10 12

My requirement is as below:

America China Europe

trade sales 40 35 45

net sales 40 100% 37 100% 50 100%

net income 10 25% 8 21.6% 15 30%

op income 12 30% 10 27% 12 24%

How do I calculate these percentages?? Please any idea to this problem would be of great help.

Thanks,

Nikki

View Entire Topic
former_member188975
Active Contributor
0 Kudos

Hi Nikki

You can try to create a formula using the function % share of (%A), like Net income %A Net Sales.

Hope this helps...

Former Member
0 Kudos

Hello Bhanu,

Problem is I have all the items in the row under a structure as they are taken from 4 to 5 different hierarchies and in the columns I have 6 entities under selection. If I wanted to create formulae I can't see the items as they are under structure.

Please let me know if I am not clear yet.

Thanks,

Nikki

former_member188975
Active Contributor
0 Kudos

So you want your columns to include the % values...may be you need to add the key figures to this structure too and then hide them. Not sure if this will give you the results you are looking for though.

However as this query has 2 structures, you may even want to try using the cell editor for these calculations...