Forum Discussion

kleighton's avatar
kleighton
Helper II
5 years ago
Solved

Table Vs Matrix

Hi,

 

I seem to be stuck in a bit of a catch22 situation, hopefully someone can assist..

I need to display a visual showing a list of projects and the products inside those projects. I need to show many fields relating to the products which i want to represent by conditional formatting (green icon) or (red icon).

 

Displaying my visual as a table, this works fine..

 

 

 

 

 

 

 

 

 

 

 

However, as you see, 1 sales project can have many sales products and this is not the best way to show the visual

So i change to matrix table

 

Better, but with the values in the "Rows" section, i cannot do conditional formatting to show the icon instead of the value

 

 

 

 

 

 

 

 

 

 

 

So i move them to "Values" section

 

 

 

 

 

 

Now i can perform conditional formatting, but once the fields are moved to "Values", they are forced with an aggregate and i cannot specify "Don't Summarize" so the conditional formatting is not working..

 

Help..