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

    How to use Exclude function

    Niranjan Banarjee

      Hi,

       

      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.