By using Custom Calculations for example you can calculate the difference between two pivot table cells percentages and percentage differences. Im working on some pivot tables at the moment and I was wondering can you create a formula which to use the range of customise field filtered field in a pivot table ie. Excel adds the value field to the PivotTable with a unique identification number appended to its name.
Years and Months are shown in the pivot table although the pivot table is not showing subtotals for each year.
The formula is very simple. Change the name if you want. The SUBTOTAL function will display the result of the visible cells only. I have been able to resolve this problem by using the free Power Pivot add-in from Microsoft for Excel 2010 and higher versions.