1 Reply Latest reply on Aug 30, 2018 11:02 AM by Joe Oppelt

    Self creating a "percent of total" calculated with a filter

    wen Jiang

      Hi,

       

      I'm hoping there is a simple solution to this, but I can't seem to find it.

       

      main issue:

      I create a "Percent Of Total" Calculated by myself, but it doesn't works well when I add a filter.

       

      Topic:

      I care about the percentage of Positive respondents in each year.

       

      Detail:

      I created a "Percent Of Total" Calculated by myself, when I select "Female" or "male", the percentage is right which is over 75%. But it is not right when i select "All" (Female and Male), it becomes 153% which is obviously not reasonable.

      My "Test Percent" is:

      {FIXED [Year],[Gender],[Statisfy]:COUNT([Statisfy])}/{FIXED [Year],[Gender]:COUNT([Statisfy])}

       

      How can I set this percentage calculation to make it work well? Any help would be appreciate.

       

      Thanks!