-
1. Re: how to hide scroll bars and/or break a tall table into two columns?
ann.stolzman Mar 8, 2016 10:55 AM (in response to Ellen Wixted)2 of 2 people found this helpfulEllen,
To hide scroll bars, right click on your dashboard item and select Fit, and select Fit Height.
As for splitting the table - I suggest creating an index calculation, add it to your worksheets, have it calculate on the state field, change it to discrete, and then filter it for the two ranges of numbers.
Hope that helps!
-Ann-
-
2. Re: how to hide scroll bars and/or break a tall table into two columns?
Ellen Wixted Mar 8, 2016 4:54 PM (in response to ann.stolzman)Thanks, Ann--now to go learn how to create an index calculation! Appreciate the response!
-
3. Re: how to hide scroll bars and/or break a tall table into two columns?
Adam Crahen Mar 8, 2016 6:09 PM (in response to Ellen Wixted)Hi Ellen-
You can use the panel chart method to split the list into two columns in the same worksheet. You click uncheck show header on row/column to hide the headers.
You need a Parameter
And a Couple Calculated Fields.
Index
index()
RowVal
[index]/[Locations per Row]
Row
if [RowVal]=int([RowVal]) then
[RowVal]
elseif
[RowVal]<0 then int([RowVal])
else
int([RowVal]+1)
end
Column
IIF(([index] % [Locations per Row])=0,[Locations per Row],[index] % [Locations per Row])
Just put State on the marks card on text
Column on Columns - compute using State
Row on Rows - compute using State
9.2 workbook attached
-
Ellen.twbx 1.5 MB
-