Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to use set analysis to limit dimension

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.

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

1 Reply
Not applicable
Author

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.