problem in report

[ashishkukreja]

I have two coloums

Months----------Sale

April--------------45
April--------------56
April--------------35
April--------------52
April--------------45
May--------------75
May--------------100
May--------------62
May--------------85
June--------------23
June--------------42
June--------------52
June--------------45

Now I want to create a report

Where column show as

Month-------------Sum of Sale------------Growth Percentage

April ---------- Total sale in April ---------- 0
May ---------- Total sale in May ----------
June ---------- Total sale in June ----------

Where Growth Percentage is contain a formula where

(Total sale of May - Total Sale of April) / 100

and similarly

(Total Sale of June / Total sale of May) * 100

How can we able to do this
Please tell me urgently

Thanks
Ashish

 

[Jon K]

Where Growth Percentage is contain a formula where

(Total sale of May - Total Sale of April) / 100

and similarly

(Total Sale of June / Total sale of May) * 100

The two formulas are inconsistent and they don't look like growth at all ?!
.