Count of Divisions Poor Avg Good V Good
Total
Grand Total
Total Avg Avg Total
Total Good Good Total Total
Divisions V Good
BAWAL 1 1 3 3 4 2 2 2 6
6
BHIWADI 3 3 3 1 1 1 4
4
CORPORATE 1 1 3 3 4
4 4
HPDC 1 1 3 3 4 1 1 1 5
5
MANESAR 1 1 2 2 3 1 1 1 4
4
Grand Total 4 4 14 14 18 5 5 5
23 23
Generate pivot this way, Instead of doing count for Poor, good, Very
Good...just simple do count of Division.
You can add formula in pivot too....go on "Option Ribbon"..then
Formula the Calculated Field
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
