7 Replies Latest reply on Dec 3, 2018 6:32 PM by swaroop.gantela

    Excluding values in a text table

    Jordan Shatila
    Jordan Shatila Nov 30, 2018 8:05 PM

      Hello,

      I am trying to reverse-engineer a workbook from a colleague who I no longer work with and I am trying to get the first image (my workbook) to look like the second image (workbook I am trying to reverse engineer).  All of my dimensions, measures, and filters are the same. If I use exclude, the numbers will re-calculate to different values... How do I exclude the 2.4%, 96.1%, and the blank value from the view while keeping the value of 1.5% the same?

       

      EDIT: Both workbooks are using the exact same data source and have the same formula for % of Total Net Sales: SUM([NetSales]) / TOTAL(SUM([NetSales]))

       

       

       

      Thanks!