0 Replies Latest reply on May 27, 2016 12:49 PM by #Mayur

    Filter function not restricting values for the Dimension...

    #Mayur

      Requirement is like,

      I have I am using 3 dimensions..

      (1).Year,

      (2).Supplier,

      And

      (3). ‘test’ column that contains values like ab, bc, cd and dc.

      I have created a fact column for the test is like, count(“test”) as test_1 in the RPD.

      2.jpg

      Sum %Not Usable= ( ab + bc )/( cd  + dc ).

      As per formula I have created the following formula like,

      (FILTER( “test_1” USING (test = 'ab'))+ (FILTER( “test_1” USING (test = 'bc')) / (FILTER( “test_1” USING (test = 'cd'))+ (FILTER( “test_1” USING (test = 'dc')))

      But it is not restricting data it is showing all the values or garbage value in the calculated column.

      Like,

      1.jpg

      Can anyone tell me how I should restrict the data as per the dimension value?

      Or is other any other solution for the same?