Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Pivot Table Question

Author  Topic 

Nick
Posting Yak Master

155 Posts

Posted - 2001-10-30 : 11:31:59
I am using the Dynamic Pivot Table sproc and am quite happy with it. I have a question on if it is possible to have more than one summary calculation though. For instance right now I'm running a report that shows how many pieces are past due on a given date (using the pivot table). But next to that column I would like to have a column that displays the total value of those units. (Qty*PricePerPart). Is that something I can do or am I going to have to look for another solution?

   

- Advertisement -