Hi All,
I have a question that I have tried to find an answer to without succeeding.
I have created a pivot table based on data from a dataconnection to a SQL database.
I now want to filter the data based on a date column.
I would like show all dates during the last 4 weeks.
Built in there is a last month and many other options but none giving this opportunity.
Is there a way to do this ? (I am using excel 2010)
Best Regards
Tomas
I have a question that I have tried to find an answer to without succeeding.
I have created a pivot table based on data from a dataconnection to a SQL database.
I now want to filter the data based on a date column.
I would like show all dates during the last 4 weeks.
Built in there is a last month and many other options but none giving this opportunity.
Is there a way to do this ? (I am using excel 2010)
Best Regards
Tomas