Hi!
I would like to create Pivot Tables that shows zero values for selected dates without existing Data...
Example:
I do have customers who don't do turnover every month. But I would like see those months without turnover also in pivot tables and charts as "zero values".
When I select the customer "B" January will be hidden in the pivot table and the connected chart.
But I need to see every month in the chart including those without data.
Image 3.jpg
Image 4.jpg
Does anybody have an idea how to manage this?
Bookmarks