Top 10 Rank Based on Total of 2 Rows
I am creating a chart that shows number of incidents per site (top 10). The chart needs to be a stacked horizontal bar that shows the number of open and number of closed incidents per site.
The Issue I am running into is when I apply a ranking to my report, it ranks the number of closed and number open per site individually, it does not rank based on total incidents for that site (see attached screenshot). This means that my chart mostly only shows the number of closed incidents per site, since those are the higher ranking numbers.
Is there a way for the ranking to look at the total incidents for the site instead of total open or closed?