Pivot Report Variable Parameter Enquiry

Pivot Report Variable Parameter Enquiry

Hi,


I wonder if you can help with this problem I have.

I have a Pivot Report (Pivot1) that pulls in data from a query table (QueryTable1).

Within the query table I have sales transaction information. Also within here I have two fields that are an evaluation of the week the app was submitted (AppWeek) and also the current week (ThisWeek).

AppWeek can be from 1 to 52. ThisWeek will only ever be one figure corresponding to the ThisWeek , ie 48.

I am trying to put a week user filter into (Pivot1) , I want the week filter to use ThisWeek as the default filter or allow the client to select another week using AppWeek.

Is it possible to have the user filter use variable data ? What I mean is how can I get the user filter to recognise the ThisWeek parameter once it changes from 48 to 49 etc ?

Im sure there is any easy way to do this but I cannot think of a solution.

Any help you can provide will be really appreciated.

Cheers,

Matt