1 2 Previous Next 25 Replies Latest reply on Nov 3, 2015 1:57 PM by Brook Bisrat

    HELP! Urgent Request, Can't Figure out how to deal with these Null's

    Brook Bisrat

      I've been searching on here for a few hours and still can't figure out how to get rid of the null values as I filter between companies.  I just want to show the rows that have values as I filter. I think it may be because I am using Measure Values and Measure Names, with a filter for Company. I tried Pivoting the data, but that screwed some things up for me formatting wise.

       

      I thought maybe create a calculate field where I say Ifnull([measure value],0) but didn't know how to do that for mulitple measures. I am really stuck, and am on tight timeline. Can anyone help. Please see attached picture.

       

      I really appreciate the help!

        1 2 Previous Next