1 Reply Latest reply on Jun 21, 2012 6:47 AM by Shawn Wallwork

# Percent Difference between two columns

Hi All

I hope I can explain this nice and clear!

Basically imagine a data set with many columns, among which there are 24 columns of data where each column contains 1 month of data.  Each row of this data set is a "customer" and the cell is their "sales" amount for the month.

How do I go about calculating the percentage difference between two months without using a table calculation?  I have attempted to build a calculation such as:

(([June 2012]-[June2011])/[June 2011])

I am then dragging in another column (let's say State) as a way to filter my results in the table view, which should give me the percentage difference between June 2012 and June 2011 by state.  If I leave the calculated field as a SUM it's definnately not right, so I change to AVG and it's still totally off and not correct.

Am I missing something here?

Thanks!

• ###### 1. Re: Percent Difference between two columns

Gareth, if you could post a packaged workbook (using the Super Store data if necessary) we can take a look at what's happening to throw off these calculations.

--Shawn