Hierarchies in PowerPivot

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

I saw one of Denny Lee’s tweets this morning titled “Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot)”, so I was intrigued since I just talked about this not being available yesterday in my PASSMN presentation.  In his example that he provided was two tables, one for the list of states and another with the city names along with the corresponding state id value reference, and he showed how even though you can relate the two tables that the results could be misleading.  If you tried to select the state name and then city name the city name would actually be replicated for each state.  Not what you would expect.

Read more...

 

Tags: excel, design, hierarchy

 

2007-2015 VidasSoft Systems Inc.