How To Keep Matrix Background Colours Max/Min Values Dependent On Only the Values in Their Rows?

JacobFraMoo — Thu, 14 Nov 2019 16:05:32 GMT

I have an issue where I need each row in a Matrix to use a RAG (Red-Amber-Green) system, but the RAG Max and Min values need to be based on data only from their concurrent rows, not all the data in the Matrix as a whole. See below for an example:

This is currently what I'm getting:

As you can see, it's getting the highest value in the matrix (100) and then using that as the max value, meanwhile 11, which is what most of the numbers are close to, is the min value. This gives the majority of numbers a reddish hue.

This is what I would like:

It takes all the data in the row itself and then assigns the highest value in that row as the max value and the min is the lowest, giving a better idea of the developments per month for each item.

I'm happy to provide more details if needed. I've tried using GROUPBY's/SUMMARIZE's but I can't seem to get it to function correctly and splitting the Fruits into seperate tables isn't an option either.

topic How To Keep Matrix Background Colours Max/Min Values Dependent On Only the Values in Their Rows? in Developer

How To Keep Matrix Background Colours Max/Min Values Dependent On Only the Values in Their Rows?