8 Replies Latest reply: Nov 28, 2017 4:12 AM by Ali Ahmad RSS

    how to show missing data in a table

    Ronit Kanfi

      I need to show a visiting report.


      The data includes:

      customer name

      project name


      date of visit


      I made a pivot table chart with the dimension:

      customer name, project name, week (from date)

      the expression is "count (date)" - in order to count how many visits were there at each project in each week.


      Only I want to see not only the project that were visited, but the projects with no visits at that week.


      How do I do that?