I often have to add or compare similar pivot tables. This is incredibly difficult and time-consuming if categories of a variable disappear when there are no occurrences.
Does anyone know how to keep categories in a table even if there are no instances?
I have attached an example. I need to add the two pivots, but the second pivot needs to have categories A3, A4, A5 etc included (with zero values obviously) before the addition can be performed.
Can anyone help?
Thanks ... in anticipation
Bookmarks