3 Replies Latest reply on Feb 13, 2019 9:17 AM by Hari Ankem

    Dynamic labelling depending on a calculation within buckets

    Paul Donnelly



      I am trying to label items as 'Essential' or 'non Essential' based on nothing more than being a product that makes up up to 50% of the cumulative sales of a certain Category, Sub-Category (and further drill downs from there).


      So for example, an item may be in that top 50% of its sub cat, but would not be within the top 50% of the wider category. So the further you filter, the items tagged as 'essential' would change. All of this would be calculated by Volume of Units sold, rather than £££.


      I've attached a bit of a dummy, hopefully it makes sense.