Adding multiple filters to a single report

[eliasdimopoulos]

Hi All

I was wondering if anyone could help me with the following report

I would like to create an incident status report (pivot) that uses multiple filters.

In addition to the normal status columns I would also like to include a "Resolved last 30 days" and "Resolved this month columns"

The report would show

• All current incidents that are not close or resolved for each member of an assignment group
• All incidents that have been resolved in the last 30 days for each member of an assignment group
• All incidents resolved this month for each member of an assignment group

Any help would be much appreciated

[vinitha3]

Hello,

You can use "Multilevel Pivot" option.

For first option - You may need to create a separate report.

For option 2 and 3 - it   can be in the same report as,

Please Hit like, or helpful if this had thrown light to you or Mark "Correct Answer" if it 100% helped you.

Thank You,

Vinitha.K

[eliasdimopoulos]

Thanks Vinitha

Close, but what I need is to include all columns on the report at the same time and to include "Last 30 Days" and "This month" as separate columns on the report.

Regards,

Elias

[vinitha3]

The conditions are not correlating, right?

Option 1 : you are filtering out status "Resolved/Closed". I dono how far the result can be valuable.

Please try to add the status filter condition in the report and check for the results. You can add the columns/rows as you need in the grouping.

Hope this helps.

Thanks,

Vinitha.K