I want to create a table chart based on criteria

[#1]

I want to create a straight table where the information shows only OPEN and CUST (waiting on customer) case information.  In other words, I don't want to click OPEN and CUST (2 of many statuses) in my Status list box to filter the straight table.  How can I do this?

[alexdataiq]

Maybe you could try using Set Analysis, tweaking your expressions, something like:

Sum({$ <Status={'OPEN', 'CUST'}>} Field)

Regards

[sunny_talwar]

Or this:

Sum({$ <Status *={'OPEN', 'CUST'}>} Field)

In case you would like to filter out OPEN or CUST based on the selection. This seems unlikely in your case, but I just wanted to introduce another option.

Best,

Sunny

[#4]

thanks, but I am not trying to sum any expressions, just display data that is pre-filtered to showing me only those cases that are open or waiting on the customer.

should this be a condition within the dimension?

[alexdataiq · Accepted solution]

Are you using a table box?

You could create a straight table and put the expression with the Set Analysis and then hide the column, Even if you're not trying to sum anything, It could be a bogus expression over a field (maybe a Count?) just so that a calculation is made and the values get displayed in the table.

[#6]

That makes sense...I will give it a shot and let you know

[chrismarlow]

Hello. I think the suggested solutions are fine, however there is another one that allows you to keep using table, i.e. not use a chart.

It is a little contrived - it involves adding another field in script, say 'Status_Check' and setting to Null() for your other statues. You can then use 'Omit Rows Where Field is NULL' on the Presentation tab of the Table box properties which has the effect of filtering.

I've attached a QVW that shows this in the lower table.

[#8]

Worked perfectly...thanks!

[#9]

This looks interesting.  My issue was resolved by another suggestion, but I will give this a try.

thanks!