3 Replies Latest reply on Nov 20, 2018 1:57 PM by Chris McClellan

    How can I sum by Quarter for measures converted to 1 if not null? Thanks

    Silvana Weinaug

      Hello, I inherit this workbook, I am not sure ..

      How can I sum the column called "ones if not null"  when I remove the dimension called "name" (see image)?



      After I removed the dimension called "name" I should get a value of 3 not 1. See the image


      The objective is for YR Qtr to have the sum of all the names. See the correct result from the below image.

      How can I fix it so it is summed correctly?

      Thank you