3 Replies Latest reply on Jul 28, 2015 9:18 AM by kiran.pinnamaneni

    How to get percentage of total (unfiltered data) after a filter?

    Li Chang

      Hi, all:

       

      I am trying to compute percentage of total after applying a filter, using attached coffee chain dataset as an example. So in the first sheet "% among all states", the label number shows exactly the right number.  But after I applied a filter (top 5 margin states in 2011), the results turn to be % of margin among 2011 top 5 margin states. Is there a way I can still get the number as shown in sheet 1?

       

      Or maybe other way, how to create a new field that dynamically groups states by 2011 margin, and hence show something as in sheet 3 "Top 5 vs. Others - how to make grouping dynamic?" ?

       

      Thank you very much in advance!

       

      Best,

      Li