Forum Discussion
Pivot - can it be
You need to make sure you are using the 'Expand All down one level in the hierarchy' option (3rd icon in on the left) to get the Teams and members.
Have you looked at the Matrix visual that should give you what you need.
I have tried this, unfortunately when you have more than one item in the Rows attribute, it does not create a step down (like I am sure it used to) but forces you do drill down. I would like to be able to see the support team, and then each staff member under that at a quick glance.
Is this not the kind of thing you are trying to produce?
Yes, that is what I want to achieve however, I would like to have the date as well as number of tickets in the details. So I would like Date to be a header. below, but as you can see, when doing this I lose the next level
This is what I can do inexcel, and is basically what I need to see
You need to make sure you are using the 'Expand All down one level in the hierarchy' option (3rd icon in on the left) to get the Teams and members.