Excel - pivot table - update data model

Question

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?

Answer 1

Generally, it works the same way - if you hit "refresh all" in Data, that should take care of it.