Is there anyway to not have it reload the whole table when I do a drill-down? The pivot table alreay takes a long time to load, just wondering why it has to reload ever time I drill-down and if there was a better way?
Check your expression. Avoid writing If statementsin expression and also in dimesnions. Both can be converted into set statements.
If you can attach the application we can take a closer look into it.
Retrieving data ...