For your second condition I would convert the values to strings and concatenate them with a "/" between the two values..
Thanks for the prompt response.
Regarding the color thing- i meant coloring the ROI column.
More general definition will be- I want to create conditional formatting (color) for each measure
For the 2 measures cell- its a nice idea, but how can i do more than one column with 2 measures cells? for example another column with ROI and it's different from average.
If you want to color the ROI field you may want to look at conditionally coloring the cell background. You can find numerous articles on this is in the forum. I would just point out that Tableau is not Excel and if you want to recreate something from Excel then you are going to be very frustrated.
As for the second point, I can put any number of cell values into one cell. str(ROI)+'/'+[Country]+'/'+[anyValueInMyData]
I think this is what you're looking for? Then if you want to use more measures, just copy the process I've done for these.
It was a fun exercise to try and figure out how to do this, but I agree with (the other) Tim that you could show this data in a more informative way than a conditionally formatted table.
Hope that helped!
Multiple meaures on text.twbx 15.3 KB