3 Replies Latest reply on Mar 8, 2016 6:09 PM by Adam Crahen

# how to hide scroll bars and/or break a tall table into two columns?

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?

• ###### 1. Re: how to hide scroll bars and/or break a tall table into two columns?

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-

2 of 2 people found this helpful
• ###### 2. Re: how to hide scroll bars and/or break a tall table into two columns?

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?

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