I want to create a Pivot Table where I will show Items sold and profit per year (row). In addition, I want to show a third metric column with the aggregated profit from first row until each row. For example, forth row (2014) will be the sum profit of 2011 + 2012 + 2013 + 2014.
I'm trying to get it with Set Analisis, AGGR and TOTAL functions, without success. Please, anyone knows how can I get it?