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.
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.
No comments:
Post a Comment