Forum Discussion
Grouped pivot table
Hello!
I've been playing around with this to see if I can get it to work, but have been unsuccessful.
Here is the way I think it might work:
1.- I add the status field as a filter.
2.- I add the agent field to the row
3.- I add the req ID field to the row, this makes the field to be placed below the agent, which is fine.
4.- I add the request date field to the row and this causes the field to be placed below the ID when it should be next to it. The same happens with all the fields.
So, how do I get the records to display as a columnar report grouped by agent?
Thank you so much in advance,
WHOHOOOO...!
It's almost exactly what I was looking for.
I just need to solve something, if you see in the image the table records have that grouping symbol that I don't know how to remove it.
And I also want to totalize the amount of records per agent.
Thank you so much again.
Good morning SergeiBaklan
Amazing! Thank you again.
Last two questions:
How can I sort by Ticket Age?
How can I add subtotals, I would like to add the subtotal for each agent
Thank you again.
You have been really helpful.