Forum Discussion

LMorman's avatar
LMorman
Icon for Helper I rankHelper I
9 years ago
Solved

how to display a null value

I am trying to create a table or matrix to represent call coverage by a Sales person.  I need to display all companies assigned to a sales person and the date they last contacted them.  The table nee...
  • ankitpatira's avatar
    ankitpatira
    9 years ago

    LMorman If I understood your question correctly you want to display blank space in a table visual if sales person doesn't have a company name (not contacted). If you're using table visual you can click on a dropdown of a field and click 'Don't summarize'. This will show you all the values including nulls.

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

LMorman

 

Please try the solutions provided by ankitpatira and philipplenz to see if it works.

I tried with following simple table and it seems that the null value can be displayed properly. Please post back what’s your table like if you still have the problem.

 

 

Best Regards,

Herbert