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



      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.



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



      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.