kar2on,


Since you are pulling the data out from the database. You can create a view/query to calculate that. Later use the EXCEL to generate the PIVOT out from it. You will like the performance of this approach.


Happy Coding

kar2on,


I have not try doing PIVOT on another PIVOT. Theorically, it should be work and will create some complexity on your design. PIVOT is so dynamic and the user allow to change the column and row at any point of time. You final PIVOT must small enought to filter which row and column to select. I am watching a twisted PIVOT tables, can you?

Back to my initial suggestion, try use the database's query/view for your data massage process. Is extra step but it will reduces the complexity on your design.

You are the one make the call. Hence, you are the one develop/maintain it.


Happy PIVOT-ing