Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
nwEVENTDTE Net Sold Qty XXX
10/13/2016 (this is what I want to solve for in an expression 8/18/2016