September 7, 2007 at 5:19 am
I'm trying to filter on subtotals in a table with 1 group level. I've created a filter in the grouping and sorting properties of the group. The report excludes all group values that don't comply with the filter.
All seems fin so far. Except in the grand total of the table the subtotal of the excluded groupvalues are added up as well. Seems that the report is just hiding the excluded groupvalues in stead of filtering it out.
Any suggestions?
July 29, 2008 at 8:39 am
Have you gotten this to work? I am running into the same thing that you're talking about. I've attempted "RunningValue" but that isn't working either. Thanks!
July 29, 2008 at 8:54 am
You would need to duplicate the filter on the grand total.
Another option may be to create a calculated column in your dataset that does the filtering.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 9:02 am
How would you do that? I've attempted with using a scope in the sum filter, but that throws an error.
July 29, 2008 at 11:03 am
In a situation where I only want to sum cd sales for cd's in the Opera and Classical categories you could do something like:
SUM(IIF(category = "Opera" Or category = "Classical", sales, 0)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply