Multilevel reporting using sumproduct
 

I have a workbook that contain several sheets of data, one sheet for each
month and a report cover page. One the report cover page I would like to make
it were the user can choose the report based on seven different variables.
(State, SVP, VP, AVP, City, MGR, and AMGR). I can get it to work if they
select all variables, however I was hoping to make it work in a way that as
they select each variable to makes the calcualtions. Kind of like a drill
down report. Is this possible?

Multilevel reporting using sumproduct
 

How do you currently have it set up so if they choose all variables it works?

Are you using combo boxes, dependant drop downs, vba?
LMK

"Scott@CW" wrote:

I have a workbook that contain several sheets of data, one sheet for each
month and a report cover page. One the report cover page I would like to make
it were the user can choose the report based on seven different variables.
(State, SVP, VP, AVP, City, MGR, and AMGR). I can get it to work if they
select all variables, however I was hoping to make it work in a way that as
they select each variable to makes the calcualtions. Kind of like a drill
down report. Is this possible?

Multilevel reporting using sumproduct
 

Currently I have it set up as two DV lists and the rest of the report sheet
just pulls of of the different data sheet. Each data sheet is formated with
formulas to feed back to the cover sheet. No VBA.

"AKphidelt" wrote:

How do you currently have it set up so if they choose all variables it works?

Are you using combo boxes, dependant drop downs, vba?
LMK

"Scott@CW" wrote:

I have a workbook that contain several sheets of data, one sheet for each
month and a report cover page. One the report cover page I would like to make
it were the user can choose the report based on seven different variables.
(State, SVP, VP, AVP, City, MGR, and AMGR). I can get it to work if they
select all variables, however I was hoping to make it work in a way that as
they select each variable to makes the calcualtions. Kind of like a drill
down report. Is this possible?