9 Replies Latest reply on Feb 14, 2020 3:57 PM by Robert Breen

Min and Max Issue

Hi All,

I want to show Max and min values for each category and each customer name.

here I attached the workbook and screenshot.

above screenshot, aaron bergman having 2 office supplies and 2 furniture and 1Technology except for furniture I want to highlight with colors min and max for office supplies and Technology

again same as remaining customers please give me the solution.

• 1. Re: Min and Max Issue

Hello Ravi,

In order to show color for each category customer, you would set up the table calculation like this.

Hope this helps! See Attached.

Robert Breen

• 2. Re: Min and Max Issue

above screenshot, I want to highlight min(red color) and max(green color) value for office supplies here -3, 2,13 are min and 10,6,261 are max values for  office supplies and the same way

I want to highlight min and max value for furniture here 5,1,49 are min(red color) and 55,2,342 max(green color) values for  furniture

and remaining technology values are showing blck

• 3. Re: Min and Max Issue

Hello Ravi,

Set up the calculation like this. I adjusted in on the attached workbook.

Hope this helps! See Attached.

Robert Breen

• 4. Re: Min and Max Issue

HI Robert Breen

Here both are 2 different categorical items But I want to show min and max  within the same categorical items except Technology

like the below screenshot.

• 5. Re: Min and Max Issue

Hello Ravi,

I'm not sure I understand what you are trying to do. Can you take this image, and tell me which ones are colored wrong, and what color they should be?

• 6. Re: Min and Max Issue

Hi Robert,

what I am saying if category = 'office supplies'  i want to highlight max and min values and same as

if category = 'furniture'  i want to highlight max and min values and

if category = 'Technology' I want to only values, not max and min

• 7. Re: Min and Max Issue

Do you want the highest for each customer and each catrgory? Is this right? If it's not, let me know which one is colored wrong.

• 8. Re: Min and Max Issue

Hi Robert,

I want to highlight max(green) and min(red) values only office supplies and furniture and

I don't want to see color for technology it's showing only black.

except for technology I want to highlight max(green) and min(red) values only office supplies and furniture

like below technology value, i want to see in black color

• 9. Re: Min and Max Issue

Hello Ravi,

I updated the calculation to force technology to always be black.

Any colors wrong now?