Remove items with no data from pivot
I have some pivots that are used in several different
sheets exactly with the same format and base external tables, where i just chenge the criteria through Microsoft Query. The problem is that the original data from the first pivot i used as a model, remains in the pivot all the time. You check this because if you choose the options "Show items with no data", all the items from my first table model will show, even if they no longer are part of the new criteria. Summarizing: is there a way to remove items with no data from a pivot field? |
All times are GMT +1. The time now is 04:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com