August 10, 2012 at 6:48 am
Hello all,
I've created a matrix which lists all rows from a table grouped on division then department in a linked table, simply using Count(id) in the details column (basically a crosstab). I have set visibility toggle ok on the department>division, but need the department level expanded for 2 of the divisions (ie show totals for all the other divisions but expand to department level for 2 divisions).
eg Finance 1 2 5 3 (division)
HR 3 2 7 0 (division)
Membership 5 5 10 5 (division)
NW 3 2 1 0 (department from Membership)
SE 1 0 2 1 (department from Membership)
LN 1 3 7 4 (department from Membership)
Policy 5 5 5 5 (division)
Tax 3 2 1 0 (department from Policy)
Corp Aff 2 3 4 5 (dept from Policy)
All ok if I set the expression as hide based on division 1 <> "xyz", the report shows totals for all other divisions but opens up for department xyz. How do I add the other division to the expression? using OR just reduces the report back to all division totals. Hope someone out there can help and also that the above is understandable. Many thanks Jules
August 13, 2012 at 5:16 am
Hi Jules,
If you're using multiple not equals (<>), then OR will return everything, as the filters just cancel each other out.
AND should work though.
Cheers
Gaz
August 14, 2012 at 6:51 am
Gaz, you're a genius, thank you very much.
Cheers
Jules
August 14, 2012 at 7:49 am
Thanks, no problem! 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply