9 Replies Latest reply: Oct 1, 2015 6:01 AM by Filiberto Cacciari RSS

    Optimize the speed of load of a pivot table

    Filiberto Cacciari

      Hi guys,

       

      who could help me please.

       

      In my QV there a pivot table that's made by a ValueList as dimension.

      So there are so many expressions based on that ValueList.

       

      The problem is that cause a QV so slow and when u load the file and when u make a filter.

       

      I attach here my QV, "Labour Cost_2", to take a look at the script of the expressions in the pivot table.

       

      My own goal would to make quicker the app. Maybe changing the formula of the expressions without using the ValueList or with others solution.

       

      Thank u so much.