I have created several pivot tables in Compound View of Answers but I have an issue with one table which I need help with.
Basically, the table has 3 headings, but the customer only wants 2 of them showing on the table. Therefore, I created 2 calculated items to select the items I require, and then selected Hide detail to remove the 3rd item. This all works fine but I now to need to convert the numbers to %, but the % calculation still factors in the 3rd item that is hidden so the figures don't add up to 100%. Is there a way to base the % just on the visible numbers?