B
Beto
Hi all,
I have a database with dates, product and quantity. After ordering by
dates x product, I keep the sum quantity in the data field.
What I'd like is to be able to group by months or years. I did it, but
I didn't like how it was.
I have access to another pivot table, connected to a OLAP database, and
the dates are in branches (Year/Month) and I'd like to do the same with
my dates, but in a branch like Month/Day. If Year/Month/Day is
possible, even better.
The OLAP pivot table worked like this:
2004 -+
|-January
|-February
|-......
......
and it has a checkbox besides 2004. If the checkbox has one tick, then
the 2004 global result is presented in the pivot table. If the checkbox
has many small ticks, then monthly detailed results are shown in the
pivot table.
I hope I made myself clear, because english is not my native language.
Any help will be appreciated, maybe a direct answer or point me to a
website.
Regards,
I have a database with dates, product and quantity. After ordering by
dates x product, I keep the sum quantity in the data field.
What I'd like is to be able to group by months or years. I did it, but
I didn't like how it was.
I have access to another pivot table, connected to a OLAP database, and
the dates are in branches (Year/Month) and I'd like to do the same with
my dates, but in a branch like Month/Day. If Year/Month/Day is
possible, even better.
The OLAP pivot table worked like this:
2004 -+
|-January
|-February
|-......
......
and it has a checkbox besides 2004. If the checkbox has one tick, then
the 2004 global result is presented in the pivot table. If the checkbox
has many small ticks, then monthly detailed results are shown in the
pivot table.
I hope I made myself clear, because english is not my native language.
Any help will be appreciated, maybe a direct answer or point me to a
website.
Regards,