durga.palepu (6/28/2016)
Yet another good alternative to learn but little complex compared to pivot solution.
It depends. Did you read the article I recommended? Pivot doesn't do so well on "End of row totals" and the like.
--Jeff Moden
Change is inevitable... Change for the better is not.