How to compare lots of data every year

gojomoso

New member
Joined
Aug 24, 2017
Messages
3
Reaction score
0
Points
0
I am trying to do an analysis on parts by both part# and customer. But within each year is a lot of data (multiple columns), which makes formatting a pivot table difficult. I'm a bit of a dummy when it comes to large sets of data and would love some direction on how to better format my data.



Thanks!
 

Attachments

  • Sample.xlsx
    11 KB · Views: 14
Hi and welcome
the easiest way is to build a table with columns
Part #CustomerProjected QuantityProjected RevenueActual QuantityActual Revenue



and a column for the date. So for each part nr you have quantities , revenues and a date
Of course you will have the same Partnumbers each year.
Starting from there building a PT is very easy
 
Back
Top