Product Trends


M

mike

Hi All,

I have created a Pivot Table as Below:

jan feb march april may june etc
Shop1 10 12 14 16 20 29
Shop2 55 57 60 45 50 44
Shop3 17 20 40 30 40 55
Etc


This pivot tables show qty of products sold. I need to find out if people
are not buyinh as many products as they used to. Please can anyone advise
on how best to do this i tried the trend fuction but i have no idea how it
works or even if this is the best solution to my problem.

please help regards

Mike
 
Ad

Advertisements

G

Gary''s Student

First just add the columns:

Shop1 10 12 14 16 20 29
Shop2 55 57 60 45 50 44
Shop3 17 20 40 30 40 55
total 82 89 114 91 110 128

Clearly you have an upward trend.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top