Create a % growth formula

[MSIsam]

I have a cross tab report in BO XI that has sales by state and month, with month along the top. I would like a formula to show % growth (month to month) instead of the actual sales quantity.

growth formula = ((Current Month-Prior Month)/Prior Month)

Layout

state Jan Feb Mar Etc.
CA 100 200 300 400
NY 10 5 20 5

Desired Result
state Jan Feb Mar Etc.
CA n/a 100% 50% 25%
NY n/a -50% 300% -75%

Thanks,
Sam

 

[skrandel]

There is a Previous function that should help.

Steve Krandel
VERITAS Software

 

[MSIsam]

Is this function available in web client for XI. I did not see it but I might have missed it.

 

[skrandel]

You didn't say that. I don't think you can do this in the Web Client yet. XIr2 will have a more complete function set.

Steve Krandel
VERITAS Software