6 Replies Latest reply on Sep 27, 2018 11:45 PM by Tushar More

    Fixed Percentage when Filtering

    Toby Bernhagen

      Good afternoon tableau community.

       

      I am working on some dummy longitudinal data, I am trying to get the percentage true to the whole even when filtering.

       

      I have been trying to use the FIXED function in regards to the responses but no matter what I do I can not accurately do it, does anyone have any thoughts?

       

      Thanks

       

       

      I though i would just be able to change the follow but can't get it to work,  SUM([Number of Records]) / TOTAL(SUM([Number of Records]))