Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a maximum number of nested IFs in a Dimension of a Pivot Table ?
It seems to me that 100 is a maximum ? Is it the case ?
If so, what is the most convenient work around ?
Thanks in advance for your time and reply
I don't think there's a fixed maximum. But every if statement means another calculation. Each nested if will mean more calculation time and ram usage and thus less performance.
The most convenient work around for the end user is to calculate the dimension as a field in the script. The most convenient short term work around for the developer is to tell the user to get lost. But in the long term that may result in unemployment.
Thanks for your feedback.
Also with 80+ nested IFs, there is no dramatical loss of performance on the particular application I am contributing to. Also, I have no access to scripting in this context.
Best Regards