| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to have total for filtered data??
I have a table with detailed sales data by product by
country. There is a grand total at the end of the sales for a total sales revenue. I did a auto filter and I selected the country I want to focus. Noticed that the grand total number doesn't change. I want it to show only the total revenue of the contry I've selected. Can anyone help? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| My Pivot total just repeats item data | Excel Discussion (Misc queries) | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
Threaded Mode
