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                            www.energyefficientbuild.com
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.