Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Currently this is the expression I am using.
=((if(caploaddate=if(GetFieldSelections([Load Date])='Today',today(),If(GetFieldSelections([Load Date])='Tomorrow',today()+1,if(GetFieldSelections([Load Date])='Day After Tomorrow',today()+2,if(GetFieldSelections([Load Date])='Three Days',today()+3,if(GetFieldSelections([Load Date])='4 Days',today()+4))))),cap)))
Currently this is changing when other selections are made. How would I go about telling the dimension to only look at the field [Load Date]?
I want the chart to only display based on an inline table that I have set to always 1 selected. Hence the long code, where I do not want it to affect other data.
Discovered it would just be easier to disconnect the tables I am using from the other tables. This broke the link so now the data is independent.
Discovered it would just be easier to disconnect the tables I am using from the other tables. This broke the link so now the data is independent.