Forum Discussion
Average & conditional formatting
abukapsoun So, I would go into Power Query, select your Items column, right-click and choose Unpivot other columns. That should make everything you are trying to do much, much easier. @ me if you need me.
Hi Greg,
In fact thats how exactly the data look like
| Items | P01 | P02 | P03 | .. | .. | P08 |
| item1 | 10 | 20 | 10 | .. | .. | 500 |
| item2 | 10 | 15 | 5 | .. | .. | 10 |
. | ||||||
. | ||||||
. |
the P01, P02.. represent periods, like months.
Every month I get an updated period that I add to the table. So if we say we are now September, i would want to analyse the figures of August.
I would want to highlight the items that are in August having value, higher than the average of the whole period.
So in September I come and look at the values of P08. If P08 value of Item1 is higher than the average of all previous periods (P1 -> P7) then I highlight the value in red. if not, we leave it.
I would need to repeat the same on every period, so if we are next in October, I would want to analyse the values of P09 while considering the average (P1-> P8).
I hope I could make it clear enough.
Thanks a lot in advance,
abukapsoun So, I would go into Power Query, select your Items column, right-click and choose Unpivot other columns. That should make everything you are trying to do much, much easier. @ me if you need me.
Thanks. Done that, but then what?
Would I be able to apply the conditional formatting to the column values if it is above the average?
Thanks you!