Friday, August 9, 2013

Google Spreadsheet Pivot Table


( by 
pindelicato )

Hi - Im using Chrome on Mac OSX 10.8.4.

Ive created a pivot table, but when I add rows or columns, it doesn't work properly.  For example, when I add a row, now rows show up other than "Grand Total" in A1.  Then when I try to add column using my "username" data, the sort by option in the box that appears in the panel shows "projectname", which is another column in my sourced data.

Please help!~


Alternate and better way of having a Pivot Table is by using a query function.
Have a look at the following screenshot:

I have the following formula in Cell A1:

=query('Sheet1'!A:E;"select A,sum(C) where A<>'' group by A pivot D order by A label sum(C) '' ")

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private and confidential projects:
If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: 


No comments:

Post a Comment