Need to suppress records from list, but include them in the subtotals

[erics]

So, I just had a really weird request asked of me.
I have a report with all the sales of salesppl. I was asked to create an abridged version that contains only sales over 70K. However, the subtotals and totals should still contain all the records.
No idea how to do this, has anyone tried this one yet?

Eric

[qvixote]

I think you should do it using javascript, using jquery it would be possible.

[Michael75]

You need two queries, one of which has the detail filter Amount > 70K.

Use the filtered query to populate your main list. Then drag another list with only the amount column (or maybe a singleton would work) under that, and populate it from the unfiltered list.

Use sizing properties etc. to make the result look like a single list.

[erics]

So, I copied my query, and on the second one added a filter where amount >= 70000
I then unlocked the report, deleted the subtotals. Then put in the value from the subquery (unfiltered amount)
Now, the report doesn't run. It starts and freezes on me.
Any advice?

[IzzyB]

Create a conditional style on the rows that sets 'box type' to none when the amount you're interested in is <70000.

The list will still run exactly the same, and the totals will be correct.