Database totals as I select filter

Muhldg

New Member
Joined
Aug 29, 2013
Messages
2
Hi all,

Got a quick question whether its possible to include totals in my database according to the drop-down I select.

I currently have a database that have 4 different variables and another tab that brings me a P&L view using sumifs according to the chosen variables. There's a drop-down which I can choose the different combinations of these variables (i.e. Sales of Brand 1 Watches in West region).

However this database has no totals. This means I don't have a specific row with the total sales of Brand 1 Watches in all regions. Including all total lines I want would be impossible as I have a huge amount of possible combinations between those variables.

Any idea I could do this in a smart and dynamic way? This means I could have further options of each variable and also a new variable in the future.

Thanks a lot!


 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,243
Office Version
2007
Platform
Windows
You can create a pivot table


 

Watch MrExcel Video

Forum statistics

Threads
1,090,160
Messages
5,412,812
Members
403,449
Latest member
Jamil123

This Week's Hot Topics

Top