Hi All,
I am wondering if there is a way of removing some blank rows I get in my pivot table when using Difference to. I have sales data for 2014 and 2015. I have the sales figures in the values, I then added the sales figures again into the pivot and this time set it to display as the difference to 2014. This in itself works however it also adds a row in the 2014 section of my pivot that holds no data - is there a way to remove it. Picture below might help you understand what I'm getting at, rows circled in red I would like to remove or not show:
Capture.JPG
Thanks,
Andrew
Bookmarks