This content has been marked as final. Show 8 replies
I need to show a visiting report.
The data includes:
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?