Make drill-downs in Pivot Tables Faster?

[#1]

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?

[deepakk]

HI Brandon,

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.

Deepak