Hi,
You can Hide and/or Exclude rows in your data table, resulting in excluding these rows in your graph.
You could even split your Column "Rooms with TV" into two new column: 1) Room Name and 2) TV Numbers using formulas
The formula are:
-
Left (:Rooms with TV, Length (:Rooms with TV) -1
-
Num (Right (:Room with TV, 1))
That way you can filter only on the room type and/or the number of TVs.
I hope it helps.
Best,
TS
Thierry R. Sornasse