4 Replies Latest reply: Aug 19, 2016 3:22 PM by Scott Wisker RSS

    Eliminating insignificant data

    Scott Wisker

      Given the following sample data set  

      Branch Product LineFY 13FY 14FY 15AveragePercent
      A100   13,150    19,768    15,924       16,281 15%
      A200   11,762    16,894    13,253       13,970 13%
      A300         175          185          157             172 0%
      A400   17,383    13,277    11,575       14,078 13%
      A500   19,807    12,934    16,306       16,349 15%
      A600   14,057    18,529    18,072       16,886 15%
      A700   18,988    16,344    18,676       18,003 16%
      A800           19            14            12                15 0%
      A900   18,879    11,578    10,084       13,514 12%
      Subtotal   109,267 100%
      B100     1,954      1,385      1,055          1,465 14%
      B200     1,596      1,404      1,749          1,583 15%
      B300     1,093      1,920      1,139          1,384 13%
      B400     2,000      1,098      1,128          1,409 13%
      B500     1,304      1,487      1,614          1,468 14%
      B600     1,883      1,497      1,972          1,784 17%
      B700           15            13            12                13 0%
      B800     1,703      1,040      1,635          1,459 14%
      Subtotal      10,565 100%

       

       

      For Branch A you can see that Product Lines 300 and 800 make up very little of their overall sales. Likewise for Product Line 700 in Branch B. Is there a way to identify these in the load script and remove them from the data set. Something similar to the Dimension Limits tab "Show only values that accumulate to 80% of the Total (for each branch)"