Multilevel Pivot Report - Group by Percentage?

mathiasjohansso · ‎03-05-2018

Hi!

I have a requirement from a customer, where they want a Multilevel pivot table to see Task SLA's based on percentage, BUT, they want to aggregate the Business Elapsed percentages to group them together in <25%, <50%, <75%, <=100% groups.

Is this possible to achieve with Reporting?

EXAMPLE:

Adam Stout · ‎03-05-2018

I think you can get something similar to this with a report using report ranges. You can't use them on a multilevel pivot but you can do it with other report types (like a bar). Also, you can't do cumulative, but you can create buckets, (< 25, 25-50, 50-75, 75-100, 100+).

For more, I would look at PA as this should give you a lot more tools and would allow you to trend this and breakdown by different key factors (like assignment group).

View solution in original post

mathiasjohansso · ‎03-06-2018

Thank you for your help, everyone!