4 Replies Latest reply on Feb 11, 2019 12:50 PM by Tom Wethern

    Filter for Market Share without changing totals

    Tom Wethern

      In the attached packaged workbook (Superstore data), I have an easy viz that looks at share by mfg by sub-category.  I would like some help in this file to understand how I can filter to see the top 5 manufacturers under each subcategory based on their share of sales.  The problem I face is that as the list of Mfgrs. is filtered out, the shares recalculate based on the new population.  (I.E. I don't need/want my top 5 to total up to 100% Share).  I would like to complete this without having to show another filter other than Subcategory.  Thanks for any help.