Product Trends
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 |
Product Trends
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. -- Gary''s Student - gsnu200840 "mike" wrote: 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 |
All times are GMT +1. The time now is 07:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com