Repeat all Items is very useful feature we have in Excel 2010 and above
We have three type of reports format in Excel.
When ever we apply ‘Calculate Items’ for addition in pivot, it increase ‘Grand Total’ its better to use grouping in data in this case. but Grouping is only applied for addition purpose we can’t apply subtraction in grouping logic. Its better when ever you apply ‘Calculate Items’ in Pivot please apply new ‘Calculate item’ for Grand Total.
We can’t insert Blank columns in Pivot.
In Excel 2016, we have search field option in pivot.
If we create all Pivot of same data source in single Pivot Chache it will consume less space and will not increase file size.