Case Study 1 Elections Data Q2 Solution

Here you need to calculate percentage of votes polled to each candidate in each constituency. If you recollect there are 543 Parliamentary Constituencies and 8,974 contested candidates. You need to create 543 reports separately. Not to worry you will get this in information in less than a minute or two.

First place cursor in any cell where source data is located, then click Insert Tab on Menu bar and click PivotTable button. Create PivotTable dialogue box is displayed. Check whether the data is correctly selected and choose New Worksheet to place PivotTable report. Click OK.

Drag Candidate Name to Row Labels, Total Votes Polled to Values, and Parliamentary Constituency to Report Filter. Click the list arrow appearing on Sum of Total Votes Polled, a popup menu is displayed, click on Value Field Settings, Value Field Settings dialogue box appears, click Show Values as tab, and click the list arrow in Show values as, scroll down and select % of Total. Next click Number Format tab, Format Cells dialogue box is displayed, from Category select, Percentage and click OK, once again click OK.

Next click the down arrow appearing on right corner of Parliamentary Constituency i.e. Page Field, a drop down menu is displayed click Select Multiple Items, and click OK. Now click the down arrow on Options tab, popup menu appears, select Show Report Filter Pages, Show Report Filter Pages dialogue box appears on screen, from Show all report filter pages of select Name of State / UT and click OK.

Don’t worry with rapid changes on screen. PivotTable is creating 543 reports on separate worksheets. It takes a minute or so. Once the calculations are done, you can see Constituency wise list of candidates with percentage of votes polled to each.