Rico Mawcinitt
New Member
Hello CHANDOO Forum -
I would like to get thoughts on what is the best way to determine if you should use a pivot table or calculated table to create/enhance your dashboard. I work a lot in data modeling and what to know more about creating sustainable data sets as they relate to pivots and calc tables.
I use a lot of pivot tables/named ranges today and find myself limited to the slicers that I can create. What are the advantages to the filtering that you can create with a calc table?
Any insights would be greatly appreciated.
Best,
Rico
I would like to get thoughts on what is the best way to determine if you should use a pivot table or calculated table to create/enhance your dashboard. I work a lot in data modeling and what to know more about creating sustainable data sets as they relate to pivots and calc tables.
I use a lot of pivot tables/named ranges today and find myself limited to the slicers that I can create. What are the advantages to the filtering that you can create with a calc table?
Any insights would be greatly appreciated.
Best,
Rico