Filtering in a cross-tab

[Former Member]

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

[JWiseman · Accepted solution]

hey David,

a formula in a cross will not filter out records (i wish it did have a filter as that would be handy) so all records in the report are available in the cross tab.

what you can do though is create a formula that will use a flag and then do a sum on that flag...e.g. change your formula to

if {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"] then 1 else 0

and then change the cross tab summary type to a Sum.

cheers,

jamie

[Former Member · Accepted solution]

Thanks Jamie this worked perfectly.