Forum Discussion

calgary_raptor's avatar
calgary_raptor
Frequent Visitor
8 years ago

Display zero instead of blank in matrix table

I have a situation where users enter data on a form and one of the values they selectare dependent on an asset area and a date. When displaying this information in a matrix table I want to display a ...
Need Help
Show and Tell
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi calgary_raptor

 

WHat your probem might be is the absence of rows int your for the intersecting points of the values on the axis.  One way to solve this is to generate dummy rows in your data.  This will allow you to display 0's

  • calgary_raptor's avatar
    calgary_raptor
    Frequent Visitor
    8 years ago

    Hi and thanks for getting back to me,

     

    I should have stated that I am pulling this data from a SharePoint on-prem list so adding dummy rows is not something I can or want to do. Any other thoughts on what I could do?