- Click on any cell of dataset / selecte all dataset > `Insert > Pivot Table` / `Insert > Pivot Table`
- Put unique values/ combinations of a column(category) as index : `Rows > Add > [Column headers of source data] `
- Put unique values/ combinations of a column(category) as columns : `Columns > Add > [Column headers of source data] `
- Pivot the values of a specified column : `Values > Add > [Column headers of source data] `
- Filter the pivot table by specified values: `Filter > Add > [Column headers of source data] `
- Custom fields : `VALUES > ADD > CALCULATED FIELD` > `FORMULA:` > `= FIELD1 + FIELD2` (fields should be exact as original dataset)
- built-in pct of grand total: `VALUES` >`Show As:` > `Percentage of grand total` (It will show numeric values) > Format data as percentages.
- Drill down on specific value : Double click on desired pivot cell
- Distribution Grouping : make pivot table with `ROWS` and `VALUES` > `Right click` on any cell from pivot table index > `Create Pivot Group Rule` > `Interval Size:`