I've been using your Budget Template, and I recently found the new "Ultimate" version video.
I used the template as a base, and worked on from there adding from my experience of the original version which I built from scratch alongside the video.
I'm having a problem adding the "Calculated Item" for the Profit/Loss Pivot table as I have a name conflict when I try to add it.
It looks like I have a Category called Income (which is no longer used) as well as Category Type with the same name. On checking I then found all of Mynda's Categories (with the icons) were still present, although I did not use any of them (I preferred to retain a normal sort order for my categories).
How can I delete these old, unused Items?
Many thanks
Colin
Go to 'Pivot Table Options' and make sure that the 'Retain items deleted .......' switch is set to None. That should fix it.
Many thanks for a very helpful reply>
I missed that totally, maybe because the wording on the Slicer options is different, and I was looking for those words.
Anyway thanks. Big help
Colin
