我希望将数据视为支点 [英] i want to see the data as pivot

问题描述

Division	 SalesOfficeDescr.	ValueBeforeTAX
30	         Vijayawada	       2134
10	         Ahmedabad	       339.5
10	         Bangalore	       2160
20	         Bangalore	       66666.6
10	         Kochi	               1150

以上数据我想看到

the above data i want see as

SalesOfficeDescr.   10            20          30            Grand Total
Ahmedabad           339.5                                   339.5
Bangalore           2160         66666.6                     68826.6
Kochi              1150                                       1150
Vijayawada                                    2134            2134
Grand Total         3649.5      66666.6       2134             72450.1

推荐答案

既然你没有提出任何问题，很难给你一个更好的答案。



我强烈建议您阅读：

如何提出问题 [ ^ ]和你有什么尝试？ [ ^ ]





PS写作解决方案，以避免这个问题在未答复的列表

Since you didn't ask any question, it is difficult to give you a better answer.

I strongly recommend you to read:
How to ask a question[^] and What have you tried?[^]


P.S. Written as solution to avoid this "question" to be in the unanswered list

我将添加到Nelek的第一个（完全有效）解决方案这个链接：



SQL数据透视表 [ ^ ]



这将引导您大约762,000这个主题的结果。



好​​读！

I would add to the first (perfectly valid) solution of Nelek this link :

SQL pivot table[^]

which will lead you to about 762,000 results on this topic.

Good reading!

这篇关于我希望将数据视为支点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！