E
eli
Hello everyone,
here is my question (thanks in advance as usual).
I have 3 columns, as follows
Date Language type
1 aug 03 english broker
2 aug 03 french client
2 aug 03 french client
The entries per day are not defined, ie could be 1 or 30
for example. The language field is only french or
english, and the type field is only client or broker.
All fields have a validation list set to them.
I created a pivot table that is done on a daily basis
with a sum, an average, and a count. Each day has a
total and there is also a grand total (at the bottom of
the fileds and the extreme right)
Is it possible to have subtotals on a weekly
basis ..automatically done or not in the pivot table ?
How would i go about this ?
Thanks
Eli
here is my question (thanks in advance as usual).
I have 3 columns, as follows
Date Language type
1 aug 03 english broker
2 aug 03 french client
2 aug 03 french client
The entries per day are not defined, ie could be 1 or 30
for example. The language field is only french or
english, and the type field is only client or broker.
All fields have a validation list set to them.
I created a pivot table that is done on a daily basis
with a sum, an average, and a count. Each day has a
total and there is also a grand total (at the bottom of
the fileds and the extreme right)
Is it possible to have subtotals on a weekly
basis ..automatically done or not in the pivot table ?
How would i go about this ?
Thanks
Eli