Forum Discussion
Help in compiling average ratings
Hi there,
I have a question about how to calculate average ratings for specific genres from a table of items with genre/rating.
I have a table a bit like the below:
M...
This is perfect for a pivottable:
- Select data
- Insert, Pivottable
- follow instructions
- Drag Genre to row area
- Drag Rating to Sigma area (bottom-right)
- Right-click in the table on the right-hand column and choose "Summarize values By...", select "Average".
- Select data
- Insert, Pivottable
- follow instructions
- Drag Genre to row area
- Drag Rating to Sigma area (bottom-right)
- Right-click in the table on the right-hand column and choose "Summarize values By...", select "Average".
