As far as I know, you can't get pivot tables to display like like that. You could filter the table but that's a pain in the arse.
Access can do it, fer sure. So long as you don't need to collaborate with anyone, then that would be the easiest way. Overkill, as Arvi said earlier.
|