I have straight table with 145 expressions. my application size is 55MB and its taking more than 1 GB RAM. Table contains metrics like vol, vol chg,% vol chg, Share, Share chg etc. I have 13 products and each product I am calculating almost 10 expressions. In some of the products, expressions are different from one to another. I can't use Pivot table why because the count of columns are not same for all the products.
Bsed on 'Next/Previous' button click, I am showing metrics in table ( At a time only one product metics). But when I am exporting to exccel I need all (145) the columns. Using conditional expression it's improving the performance but order of the rows in the table changing. If I am using hiding expression(presenation tab)
functinality, order of rows not changing but its taking more RAM.
Please give your suggestions to improve the performance( Reduce the Ram usage)
