In a normal Pivot table how do i color particular rows ( all rows greater than 800) and sort the rows in a order.
Wanted to Highlight the rows 800 - 1000 and the dimension to be sorted as 0 -600,600 - 800 & 800 - 1000
Attaching the QVW file for reference.
Have got the anser for my question but in the grouping currently i am showing number of agents in each bucket instead of it i need to show no of instances means if one agent has touched 0 -600 bucket tow days in teh month it should show two instrad of showing 1 as Average
