Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stock Trends | Excel Discussion (Misc queries) | |||
Up/down arrows to show trends | Excel Discussion (Misc queries) | |||
Forecast and Trends | Excel Worksheet Functions | |||
fill rate trends | Excel Worksheet Functions | |||
TRENDS | Excel Discussion (Misc queries) |