Pivot Report Combined Year Logic

The AceViewer Pivot Report uses what we call “standard catalog fan-out” when combining years. This means we only have one path from make -> model -> year -> engine -> notes -> part. Each year is only listed once (possibly in a block) for a make/model.

For example:

Toyota:
  Camry:
      2001-96
           2.2L: P1
           3.0L: P2
       1995-94
           2.2L: P1
           3.0L: P3
           …  

Note that the 1996 3.0L and 1995 3.0L parts are different. That is what kept the entire block from being 2001-94.