Forum Discussion
formatting and equations
Hi! I am hoping to make my work a little easier. I have an excel worksheet I am using to get data from but in order to do I am needing to do a lot of steps. Here is an example of my worksheet, th...
EmilyDyer I think this can be done using a pivot table.
- Make sure your data has a row with unique headings. Then press control+T to format the range as a table (check the "My table has headings" check-box).
- Click Insert, Pivot table
- Drag the category column to the Rows area
- Drag the column with the numbers to the rows area
- Right-click that last added column in your pivot table and choose "Group". Set it to this:
- Drag that same field into the Values area
- Right-click inside that area in the pivot table and choose "Show Values As", "% of parent row total".
I end up with this: