Generally, pivot table only displays the items that actually
have data in the source. But the requirement is pivot table that displays the
total amount for all items that having null value/ without data like Microsoft excel.
(Last updated on: June 24, 2019).