I have a list of states and values, which I would like to break into two columns. I couldn't find an easy way to accomplish that (advice on a better approach?) so I duplicated the worksheet and put two of them side by side on a dashboard, as pictured below.
Inelegant as this solution is, it sort of works. However, the scroll bars look awful. How do I hide them?
Ellen,
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-
Thanks, Ann--now to go learn how to create an index calculation! Appreciate the response!
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