I am working with a pivot table and need the functionality of counting distinct items. To do this I click the option to 'Add To The Data Model' at the bottom of the 'Insert Pivot Table' dialogue box and everything work fine.
The issue is after I build a pivot table off of the data, how do I add new rows or columns. With a typical pivot table, I'd Click the analyse tab, select the new data range and hit refresh.
Is there a way to do this for a pivot table where the data has been added to the data model?
