Set Analysis with Dates

[evansabres]

I have a field called 'nwEVENTDTE' (the event date) and another field called 'XXX' (the event date minus 56 days)

I have another field called [Net Sold Qty]. I have created a chart that uses the nwEVENTDTE as the dimension and what I want to do is to create an expression that gives me the [Net Sold Qty] for nwEVENTDTE - 'XXX'?

Is this possible?

[swuehl]

If you are asking how a set analysis can be evaluated in the context of a dimension, then have a look at this discussion

Evaluating "sets" in the context of a dimension

If you are asking for something else, then please post some sample lines of data and a description of your model and your expected result.

[evansabres]

nwEVENTDTE                  Net Sold Qty                                                                                            XXX

10/13/2016                            (this is what I want to solve for in an expression                                8/18/2016