cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate % based on row

Former Member
0 Kudos

Hi,

Could anyone pls. help me in calculating 5 at row level.

My data is in following for in report

Store Yes No To

S1 4 3 2

I want to calculate the % of each value based on row.

ie.

Store Yes No To

S1 44.44% 33.33% 22.22%

Thanks in advance

Tarun

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Tarun,

in Query Designer you have a structure for your key figures. Create formulas for

1. mySum = Yes + No + To

2. myYes = Yes % mySum

3. myNo = No % mySum

4. myTo = To % mySum

Hide mySum and your original key figures in properties, so only myYes, myNo and myTo are shown.

Best regards,

Björn