Talk:Pivot table
From Wikipedia, the free encyclopedia
 |
This article is within the scope of Computing WikiProject, an attempt to build a comprehensive and detailed guide to computers and computing. If you would like to participate, you can edit the article attached to this page, or visit the project page, where you can join the project and/or contribute to the discussion. | |
| ??? | This article has not yet received a rating on the quality scale. | |
| ??? | This article has not yet received an rating on the importance scale. | |
 Archives |
|||
|
Contents |
[edit] Please explain the concept with examples
This article currently doe not live up the the Wikipedia standard. I am not familiar with pivot tables. I came here to learn what it is, but I still do not understand what it is after reading the article. Could a knowleadgeable person please rewrite the article to be concise, and add some examples? Also, I find it irrelevant that the name is a trademark of Micro$oft Corporation. -- PeterThoeny - talk - 2007-02-17
- The example now makes it clear. Thanks for making this article accessible! -- PeterThoeny - 06:18, 2 March 2007 (UTC)
The text under the second sample table seems to confuse rows and columns: " pivot table usually consists of row, column, and data (or fact) fields. In this case, the row is Region, the column is Ship Date, and the data we would like to see is Units. " My understanding (since VisiCalc in the 1980s) is that a row is horizontal and a column is vertical. In the table being described, the Region is a column header and the Ship Date is a row header. Am I thinking backwards or is the example presented backwards? 65.82.126.100 (talk) 20:43, 23 April 2008 (UTC) Cajun Charlie - 23 Apr 08
[edit] Regarding above complaints
I've since fixed up this article, and would like to clean up the discussion page. I'm not sure if I have to archive anything or just delete it. Could someone verify the issues have been addressed, and clean up the discussion page? Wikidan829 14:04, 8 March 2007 (UTC)
- Archived. -- Avi 14:32, 8 March 2007 (UTC)
[edit] Fair use rationale for Image:Pivottable-Flatdata.PNG
Image:Pivottable-Flatdata.PNG is being used on this article. I notice the image page specifies that the image is being used under fair use but there is no explanation or rationale as to why its use in this Wikipedia article constitutes fair use. In addition to the boilerplate fair use template, you must also write out on the image description page a specific explanation or rationale for why using this image in each article is consistent with fair use.
Please go to the image description page and edit it to include a fair use rationale. Using one of the templates at Wikipedia:Fair use rationale guideline is an easy way to insure that your image is in compliance with Wikipedia policy, but remember that you must complete the template. Do not simply insert a blank template on an image page.
If there is other fair use media, consider checking that you have specified the fair use rationale on the other images used on this page. Note that any fair use images uploaded after 4 May, 2006, and lacking such an explanation will be deleted one week after they have been uploaded, as described on criteria for speedy deletion. If you have any questions please ask them at the Media copyright questions page. Thank you.
BetacommandBot (talk) 21:57, 5 December 2007 (UTC)
[edit] Fair use rationale for Image:Pivottable-Pivoted.PNG
Image:Pivottable-Pivoted.PNG is being used on this article. I notice the image page specifies that the image is being used under fair use but there is no explanation or rationale as to why its use in this Wikipedia article constitutes fair use. In addition to the boilerplate fair use template, you must also write out on the image description page a specific explanation or rationale for why using this image in each article is consistent with fair use.
Please go to the image description page and edit it to include a fair use rationale. Using one of the templates at Wikipedia:Fair use rationale guideline is an easy way to insure that your image is in compliance with Wikipedia policy, but remember that you must complete the template. Do not simply insert a blank template on an image page.
If there is other fair use media, consider checking that you have specified the fair use rationale on the other images used on this page. Note that any fair use images uploaded after 4 May, 2006, and lacking such an explanation will be deleted one week after they have been uploaded, as described on criteria for speedy deletion. If you have any questions please ask them at the Media copyright questions page. Thank you.
BetacommandBot (talk) 21:57, 5 December 2007 (UTC)
[edit] Fair use rationale for Image:Pivottable-Flatdata.PNG
Image:Pivottable-Flatdata.PNG is being used on this article. I notice the image page specifies that the image is being used under fair use but there is no explanation or rationale as to why its use in this Wikipedia article constitutes fair use. In addition to the boilerplate fair use template, you must also write out on the image description page a specific explanation or rationale for why using this image in each article is consistent with fair use.
Please go to the image description page and edit it to include a fair use rationale. Using one of the templates at Wikipedia:Fair use rationale guideline is an easy way to insure that your image is in compliance with Wikipedia policy, but remember that you must complete the template. Do not simply insert a blank template on an image page.
If there is other fair use media, consider checking that you have specified the fair use rationale on the other images used on this page. Note that any fair use images lacking such an explanation can be deleted one week after being tagged, as described on criteria for speedy deletion. If you have any questions please ask them at the Media copyright questions page. Thank you.
BetacommandBot (talk) 05:52, 19 December 2007 (UTC)
[edit] Consolidation
I was under the impression the act was called data consolidation and the button to press on excel was pivot table. if they differ please specify. thanks --Squidonius (talk) 20:42, 7 May 2008 (UTC)
- Hi Squidonius. Data consolidation appears to be more relevant to combining two or more datasources together, not the same as aggregating data from a single datasource. Wikidan829 (talk) 17:08, 21 May 2008 (UTC)
