Color data by comparison
Hi everyone,
this forum has helped me a lot before, thanks for sharing your knowledge! This is my first post:
I'm trying to highlight entries in a column based on their text. We have several products that can have different article numbers. So i added a comparison in order to summarize them: article-number22, article-number28 and article-number43 = product1. article-number55 and article-number72 = product2.
I then built a customer table with their product sales.
Is there a way to mark all product1 in green and product2 in blue?
Kind regards and thanks a lot in advance
Michael
1
Comments
Like this?
You can change the color of rows by rightclicking on the row:
Dear Marlene,
thank you for your quick reply! Yes and no:
I can change the Background of the row. But each product is being purchased by different customers. And I need all the different products in one color, each, for instance here all product2 in green.
Best regards
Michael
Sorry I can't help in this case, but If it is possible in a way I would be interested in the solution ;)
maybe a rank on product (alphabetical), and then add colors to the rank measure?
Please sign in to leave a comment.