Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 7 table charts on a sheet. Each has around 5-6 columns and couple of hundred thousand rows. I want users to not be able to select from any of those charts. They should be able to scroll down the table but shouldn't be able to select any row or a cell from those tables. Something like a Read only table box. As I see a read only property on a list box I don't see a similar property on a table box.
Is that possible with Table charts ? How ?
You don't need an expression to use a straight table. But if you don't have any expressions, you DO need to uncheck "suppress zero-values" on the presentation tab. Do that, and your dimensions should pop right up. It would be nice if that was the default behavior for a straight table with no expressions, but for some reason it isn't.
Charts have a read only option (on the general tab of properties), couldn't find one for Tablebox. It is however possible to put a transparent text object on top of the whole sheet to make it completely non interactive.
How about just changing the table boxes to straight tables? You can make it look exactly the same if you want, but a straight table gives you a lot more control. In this case, it lets you set it to read only.
Would it surprise you if I say I tried that already and did not work out. I think I can't use the chart as I am not reporting any expressions or metrics. Data is purely dimensional without any calculation. So, when I use the straight tables chart it doesn't display any data as there are no expressions. May be I am wrong.
You don't need an expression to use a straight table. But if you don't have any expressions, you DO need to uncheck "suppress zero-values" on the presentation tab. Do that, and your dimensions should pop right up. It would be nice if that was the default behavior for a straight table with no expressions, but for some reason it isn't.
Thanks John. You were right. Supress Zero values on presentation tab of the chart worked. I converted all my purely dimensional table boxes to table charts.