No actually i heard about there is only 125 dimentions are okay with QV-11 but when we increase then that the pivot table structure is distracting i mean not showing sub totals correctly as per the expected ...Top becomes left side showing when we cross 125 dimention selection ..
1. You are using conditional show to not show all 125 dimension at one time.
2. You have been altering the column order by drag and drop.
These two in combination probably means that you no longer are in control of your actual column order. So the your expectation might not be in line with your current setup.
From experience of larger pivot tables, I doubt that you will be able to properly maintain or validate the table with +30 dimensions. With complex expressions you are likely to put great load on memory and CPU to process the object, and it also becomes a terrible end-user experience.
My suggestion: re-design your application to have several smaller pivot table or even graphical chart to allow users to properly explore the data and make their discoveries.
