Wednesday, September 21, 2011

yogi_Create PivotTable From Form Data Get Counts By Specified Attributes Publish PivotTable

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
Data is submitted via a Form for Car Class, Drivers Name and Racing Yes or No.
Need to create a single PivotTable by Car Class and Drivers Name showing who is racing, who is not racing and their respective counts
In the proposed solution here, I created two computed fields (shown in light brown background) to x mark Race or NoRace ... this works out nicely showing the needed information.