To enable automatic insights – click on Home > Ideas.
Ideas opens a pane on the right side.
Several suggested queries are given.
You can ask your own questions.
You can even choose the fields that interest you the most.
Every field can be summarized as Sum / Average / Not a value.
Fields can also be excluded.
You can also add the result as a separate PivotTable.
GET SAMPLE FILE AND SOLUTION
Send an email at: