H
HenrikH
Hi, I have a Excel Pivot that shows data from a SQL database. The data
i working hours for employees per client.
I want to filter the data by date in the Pivot. To day i do the
filtering in MS Query and the Pivot recieves the filtered data from
the Query.
I would however like to insert to date field in the spreadsheet ; Date
from and Date to and have the Pivot updated using this filtering. I
gather its has to be done by having the MS Query use the datefields
from the Pivot - but cannot figure it out.
Anyone?
i working hours for employees per client.
I want to filter the data by date in the Pivot. To day i do the
filtering in MS Query and the Pivot recieves the filtered data from
the Query.
I would however like to insert to date field in the spreadsheet ; Date
from and Date to and have the Pivot updated using this filtering. I
gather its has to be done by having the MS Query use the datefields
from the Pivot - but cannot figure it out.
Anyone?