Hi,

In a pivot table, there are 4 possible columns. However, on some occasions, there is no data for one of the columns and the pivot table automatically omits it. Is there any way to set it so that it will ALWAYS have those 4 (and only those 4) columns ? example below


What is shown:


Column A Column C Column D
Person A 3 5
Person B 4 2 5
Person C 6

what i want to see:

Column A Column B Column C Column D
Person A 3 5
Person B 4 2 5
Person C 6



thanks!
C