2 Replies Latest reply on Jul 4, 2016 7:43 AM by JayC

    % of Total Excluding Few values using Data source filter


      Hello All,

      I am stuck in one of the reqmt and in need of assistance.


      I have dimension Channel with values (A,B,C and D) and have measure Sales.

      I want to take the % of total sales across Channel  BUT excluding few of the values (say A and B) using data source filter. Total should not be 100%.


      Tried Index() and it works only when data has the required entries available. Since data is restricted using data source filter i don't know any other ways to tackle this.

      Please Help!