To enable automatic insights – click on Home > Ideas.

01.png

Ideas opens a pane on the right side.

02.png

Several suggested queries are given.

03.png

You can ask your own questions.

05.png
05.png
06.png
07.png
09.png
08.png
10.png
11.png
12.png
13.png
14.png

You can even choose the fields that interest you the most.

15.png

Every field can be summarized as Sum / Average / Not a value.
Fields can also be excluded.

16.png

You can also add the result as a separate PivotTable.

17.png
18.png

GET SAMPLE FILE AND SOLUTION

Send an email at:

havish@havishmconsulting.com 

  • LinkedIn
  • YouTube
  • Instagram

©2020 by HAVISH M. CONSULTING. Proudly created with Wix.com