Changing values to percentages

[dhulbert]

I have a report as shown below

          product1          product2
          Var1   Var2       Var1   Var2

Week1     180    20         400    100
Week2     150    50         200    200

The reports is created in a matrix and works fine but I've been asked to change it to show the values as % so

          product1          product2
          Var1   Var2       Var1   Var2

Week1     90%    10%        75%    25%
Week2     75%    25%        50%    50%

Any help would be greatfuly appreciated.


I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[FlaBusInt]

What's your data source? I'm thinking the easiest way would be to do the calculation in your proc or cube.