Mighty Morphing Pivot Tables or: How I learned to automatically change hierarchy levels on rows
Typical Client Report Requests
- Simple but complex
- High-level yet detailed
- Compact yet containing everything…
Quite understandably, clients love to channel their inner Marie Antoinette by basically asking to have their cake and eat it too. I actually relish those scenarios, they allow me to flex my “think outside the box” muscles! And hey, it’s great to be working with a toolset that truly CAN accommodate the special demands posed by real-world situations.