1 Reply Latest reply: Oct 24, 2013 4:09 AM by 1035431 RSS

    Calculated Item Issue in Answers

    9095d807-23e9-4828-bd31-a2f73e53d988

      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?