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 .
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.
Please find my calculation below to highlight the one(s) meet the criteria.
Hope this helps
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...