I'm trying to use the P&L Pivot table and I just need a quick hand with a few things
1. Change format so that it looks more like my normal pivot table, with each sub category of interest/income showing
vs
2. I need to create custom rows, nothing fancy I just want to have a row showing income - expenses excluding tax, and and one showing income - expenses. I'd like to create these rows without altering the underlying data set.
Any help would be greatly appreciated.