Skip to Content
0
Former Member
Mar 13, 2007 at 05:39 PM

How to find growth %

18 Views

Hi all,

I had the following scenerio. I have to build a query for the following..

year : April(sales) : May(sales) : June : .........May(sales): total : Avg : Growth %

2003 : 20....................................................40............:100..: 20....................

2004 : 30......................................................50............:120..: 20.........30%......

2005 : 40......................................................60............:150..: 30.........50%......

Please help to find out above scenerio.

Thanks,

James.