Forum Discussion
conditional formatting with icon or colour that compare two columns in percentage changes?
Dear all : good day here, thanks for letting me to post the question here and thanks for your time on reading this. I have a matrix dummy here that I would like to ask how can I add ie : it...
Hi thanks for the reply
does that mean u suggest I transform the raw data cab into two table in follow arrangement .
ItemID | Shop 1| DiscountRate | Value
ItemID | Shop 2| DiscountRate | Value
and then there is a chance I have a way to compare them in a matrix visual?
again many thanks for pointing a way
lbendlin
Super User
Super UserDon't do separate tables. This should be all in one table.
| ItemID | Shop | Discount | Value |
| 12 | Shop1 | 78 | 444352 |
| 12 | Shop2 | 78 | 346760 |
| 12 | Shop1 | 80 | 20 |
| 12 | Shop2 | 80 | 20 |
etc.
My raw csv file comes in like this:
ItemID Shop1 Shop2 Discount
12 10000 12000 78 12 9000 8000 78 10 80 109 80 9 900 100 90 so far and so on.
what is the best solution or direction I should look into? Thanks