Need Help

[paulwalker]

Hi Community,

I have a tab within one of my documents which contains a Pivot table of data. The table has 2 dimensions and around 50+ expressions.

when i am open application, it's taking almost 10 to 15 mins time.

Please can you suggestion's..

How to boost performance ??

[paulwalker]

Hi All,

Sorry for delay...

Actually i have expression's like this..

How to convert into Set expression.......

=sum(aggr(if(NID=FirstSortedValue(TOTAL <PID> $(variable),-$(variable))  AND Time<>'N/A', Jobs),NID, PID))

Please anyone can help me...!!!!