I have a requirement where I need to display the prod. categories which do not have any sales in any of the quarters in the cross tab. Also the requirement is to show the total sales in all quarters per prod. category (Check the last column added in the sheet).
Please check the attached file for your reference. All new things required are highlighted in yellow.
What about "suppress missing"? In general, it is often better to deal with this on the data model level - load 0s when there are no sales. Even if you add 0s to each Prod_Cat/Quarter combination, it wouldn't hurt.
Try to add "partail" sums to another dimension.
If it doesn't help - can you attach your application?