Forum Discussion

bundipapa's avatar
bundipapa
Helper I
3 years ago
Solved

How to keep row header when no data

Hello, probably another stupid question, but I would need to know, if it is possible, to keep the row header and show empty field when the line would be normally filtered out. I have to create ...
Need Help
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi bundipapa 

     

    Add a Dim Product table to your model which has all distinct product values, and connect it to the original table on Product column. 

    Then use Dim Product table's Product column on rows of the matrix and select "Show items with no data" option for it. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi bundipapa 

 

Add a Dim Product table to your model which has all distinct product values, and connect it to the original table on Product column. 

Then use Dim Product table's Product column on rows of the matrix and select "Show items with no data" option for it. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • bundipapa's avatar
    bundipapa
    Helper I
    3 years ago

    So easy and yet so genius. Thank you very much