1 Reply Latest reply on Feb 8, 2017 11:41 AM by Patrick Van Der Hyde

    How to use Exclude function

    Niranjan Banarjee



      I want to calculate Category Mix/Share/%.


      Hence used the formula (([C Value]) / SUM({FIXED [Country]:([C Value])}))*100 based on my requirement with Category dropdown having only A1, A2,A3,A4.


      Now, had to introduce Category A = A1+A2+A3+A4 and B= A1+A2+A3 in the Category DropDown.


      Logically, I need to exclude Category A & B inorder to arrive at the correct calculation of Category Mix/Share/%.

      So, when i am trying to show only the Category B 's Mix numbers as per the below picture it provides me wrong 100% which is wrong. Help me resolve it.