I want to make a pivot table which shows totals for 4 categories, within a range of years. At the top of the table, I want a total for the years before 2005 (or another year of choice).
fields are year, category, amount.
Example:
| year | category | 1 | 2 | 3 | 4 |
| <2005 / other | | € 170.000 | € 62.000 | € 33.000 | € 25.000 |
| 2005 | | € 10.000 | € 7.500 | € 6.000 | € - |
| 2006 | | € 12.000 | € 1.000 | € 5.800 | € - |
| 2007 | | € 13.000 | € 800 | € 5.700 | € 100 |
| 2008 | | € 27.000 | € 3.000 | € 5.600 | € 500 |
| 2009 | | € 27.500 | € 3.500 | € 5.500 | € 400 |
| 2010 | | € 28.000 | € 4.000 | € 5.700 | € 600 |
| 2011 | | € 29.000 | € 5.000 | € 5.800 | € 800 |
| 2012 | | € 30.000 | € 3.400 | € 3.400 | € 750 |
| 2013 | | € 28.000 | € 3.500 | € 2.800 | € 900 |
| 2014 | | € 34.000 | € 3.600 | € 2.900 | € 1.000 |
| 2015 | | € 50.000 | € 4.000 | € 3.100 | € 1.050 |
| 2016 | | € 60.000 | € 4.100 | € 3.700 | € 1.100 |
I saw that dimension limits in a pivot table is not possible. How should I go about achieving this?
Any help would be very welcome!
