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!
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!
