I want to graph the totals by week by combination of unique values from the
first four columns. For that I created 4 combo-boxes (not in a form), each
one containing all the possible unique records on that column, I also
included an €œall€� item in each list for those cases where the user wants to
see €œtotals€� of all columns or certain combinations.
The idea is similar to a pivot table. I concatenated two fields (columns)
and graphed them by using €œsumif€� now the user is asking for more
€œquery/filter€�options but I dont find the concatenation of all 4 columns
any practical and besides, I dont know how to incorporate the €œall€� to the
€œsumif€� other than several nested €œifs€�
Any suggestions?

The headings of the data is as follows

Cntry- Plnt-Wrhse-Ctgry Week1 Week2 Week€¦€¦€¦€¦..