Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Custom Groups + Filters

Custom Groups + Filters

Custom Groups + Filters

Is there a way to filter on the elements of a Custom Group
WITHOUT placing the individuals filters in EACH on the groups?

Currently I have created a Custom Group based on a Metric qualification. This metric qualification is based on the month (attribute 1) and brand (attribute 2). In order to produce the correct results I must place the filters on ATTRB 1 and ATTRB 2 in each on the 8 elements of the Custom Group. Although this solution works, I is much easier to somehow create a custom group and add the filters to the global report instead of each individual level of the custom group.

Any thoughts?

RE: Custom Groups + Filters

Have you created a set qualification in the custom group and tried putting the filter in the report?

RE: Custom Groups + Filters

I'm not sure what you mean by 'set qualification.'
I've only tried recreating the custom group based on the metric qualification and eliminating the two filters. Instead of placing the filters in each group of the custom group, I placed the two filters on report.

RE: Custom Groups + Filters

a more elegant solution is to create a filter object with month and brand.  Name this filter F1.
then in your CG elements, link them to F1.  
Now when you change F1, all the CG elements are automatically changed as well.

RE: Custom Groups + Filters

In order to get the correct result I used an attribute. However, I had to create a seperate hierarchy. The metric solution would be cleaner if a non aggregating function could be used (NOT Max or Min because I would like all the messages to be displayed.)

RE: Custom Groups + Filters

sorry, that post was for a different thread.

anyway, the solutions that are proposed do not solve the problem. I dont want the filter in the custom group. there are over 30 reports that use the custom group w/ different combinations of the 2 attributes. I would like to create ONE custom group and apply a different filter to each report.

RE: Custom Groups + Filters

one way the tech support guys have told me is a workaround is to use a filtered metric in your reports.  ie. instead of putting the filter at the report level, place it in the metric used by the report.   in any case, still lots of overhead maintenance...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close