How to filter out rows on straight table?

[#1]

How do I filter out rows of data on a straight table? I can't figure out where to the set analysis

Basically i have a field Ideas.Status and i only want those with values of Delivered or Rejected shown

[mazacini]

Hi Alex

You can use Set Analysis in the expression in your straight table.

So for instance of you were summing the values of FieldName for dimension Ideas.Status, your expression would be Sum(FieldName), with Ideas.Status as your dimension

But to restrict, Sum({<Ideas.Status={'Delivered,Rejected'}>}FieldName)

Hope this helps.

Joe

[marcus_sommer]

Perhaps as dynamic dimension like if(match(Ideas.Status, 'Delivered', 'Rejected'), Ideas.Status) and then check on "hide Null-Values".

- Marcus

[sujeetsingh]

you can filter out by using some filters or some variables

[#5]

This may be a silly question, but where do I enter the expression? There is no expression tab on the properties for a table box

[#6]

cool. where exactly would i enter this though?

[#7]

where are these filters though?

[marcus_sommer]

[mazacini]

Hi Alex

I picked you up wrong on the terminology.

You are using a table box, not a straight table (which is a chart type)

The table box simply lists the table entries for the field selections you make in the properties window.

If you simply want to list for Delivered and Rejected, just display the list box for Ideas.Status, and select the relevant values - your table box will only display for these selections.

Hold Ctrl button while clicking multiple entries in the list box to display associated data in your table box.

Joe

[sudeepkm]

Writing expressions is not available in a Table box Object. In Table box you can only enable Drop Down for your fields.

To use expressions (set analysis or any other expression), you need to create a Chart object > Straight Table.