Skip to Content
0
Former Member
Jun 06, 2013 at 08:12 PM

Filtering in a cross-tab

21 Views

Good Day To All,

I have a series(3) of cross-tab on a report.

I created a formula to filter in just the categories I want.

I created a formula called Category_Specific and it looks just ike this.

{Command.CATEGORY_CODE} in["6 Month Recertification","Ad Hoc Report","Absence Management","Email Processed - Company Level P","Email Processed - Employee Level P","Email Received","Email Re-tiered","Inbound Call","Inbound Disability Report","Outbound Letter","Voicemail Processed","Voicemail Received"]

In my cross tab in the Summarized field section.

I have Count of @Category_Specific

For some reason it is not filtering the other Category code out. In other words all categoies are being summarized

Any thoughts

Regards,

David Martinez