Simple question re: straight tables

[cfountain72]

Can someone tell me if, when using Straight Tables, you can keep the full or Top X list of values, instead of only showing the selected one(s)? In other words, use the behavior found in the List Box, but I need to show multiple columns.

Thanks in advance,

Chris

[Anonymous]

Are you talking about Top/Bottom analysis in Straight Table?

[jonathandienst]

If you have a column that is independent of the selections, either by using a set expression override of the selections, or a constant value, then the rows will always display. In a straight table you can hide this column in the presentation tab.

[Anonymous]

is this you are looking for??

How to display Top 5 records in straight table

Pivot Table top 10

Top 10 rows and total of top 10

[cfountain72]

Thanks Jonathan,

Haven't moved into Set Expressions yet. I did create a simple Constant (1) value to add as a Dimension to the straight table. But, when I click on a row, all of the other rows still disappear. Do you have an example of what you have described?

[jonathandienst]

Add the constant as an expression, not a dimension.

To ignore selections in a field, use a set expression like the examples below:

     Avg({1} Amount)                              -- ignore all selections

     Count({<Group=>} ID)                      -- to ignore selections in Group

     Sum({<Region, Month>} Amount)      -- to ignore Region and Month selections (the = is optional)

[#7]

Hi Chris,

You may try Dimension Limits Tab to look for top n values.

Thanks

SV