Explanation
Subtotal can be used for more detailed analysis.
For example, data can be organized by:
City → Category → Sales
You can use outline controls to expand and collapse different levels of detail.
Example
|
City |
Category |
Product |
Sales |
|
Hisar |
Accessories |
Mouse |
5000 |
|
Hisar |
Accessories |
Webcam |
10000 |
|
Hisar |
Hardware |
Monitor |
17000 |
|
Sirsa |
Accessories |
Keyboard |
4000 |
|
Sirsa |
Hardware |
Monitor |
25500 |
|
Sirsa |
Hardware |
Printer |
12000 |
The outline controls allow you to view:
- Overall summary
- City-level details
- Complete transaction details
Practice
Create a City-wise subtotal and use the outline buttons to show/hide details