show all results on a simple table

[#1]

Hi Everybody,

I have a simple table with 2 dimensions, and I want to be able to select a field inside that dimension and still be abble to see all data from the table (in gray like a list). I dont want to only see my selections.

I really hope that this is possible.

thank you beforehand!

[#2]

Hi,

PFA

Hope this will be helpful

[Gysbert_Wassenaar · Accepted solution]

For that you'll have to use a straight table instead of a table box. See attached example.

[#4]

it is perfect! nonetheless when I select a field the others turn gray (which is perfect) but when I create the tables it does not change colors. Do you know how to do that?

[Gysbert_Wassenaar]

Click on the + in front of a dimension on the Dimensions tab of the charts properties window. Then click on the Background Color and then click the Edit button. In the expression editor you will find the expression that calculates the background color for that dimension.

[#6]

Thank you very much for your help!!