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

      visiter

      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?