2 of 2 people found this helpful
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!
Thanks, Ann--now to go learn how to create an index calculation! Appreciate the response!
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]/[Locations per Row]
if [RowVal]=int([RowVal]) then
[RowVal]<0 then int([RowVal])
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