1 Reply Latest reply on Sep 11, 2018 11:03 PM by Zhouyi Zhang

    To Find Which product subcategory contributes more profit than appliances, but less than chairs and chairmats using Superstore Dataset

    DHRITIMAN BANERJEE

      Hi Everyone,

      I need to find the correct logic where I want to find the product sub category which more profit than appliances, but less than chairs .

      Capture.PNG

      Here, i want to mark chairs and show it by different colour as it is more than appliances but less than chairs.

       

      I need the correct calculated field logic so I can mark those sub-categories which fulfil the conditions above .I do not want to use set and make the calculation dynamic

      Similarly, can i find sub-category if i use take two sub-category values using parameters and to find those values of sub-category by profit which are between the two selected sub-category ranges.