Hello,

I wanted to see if someone could help me create a calculated field

I have two fields [CY PAX], [CY NET WEEKLY PAX], and [WEEK ENDIN

I simply want to add them together [CY PAX] + [CY NET WEEKLY PAX] but I wan't to the [CY NET WEEKLY PAX] value to stay filtered to [WEEK ENDING] = #08/04/2018#

So the [CY PAX] with change each week but I want to always back the Values from [CY NET WEEKLY PAX] on 08/04/18.

Any help would be greatly appreciated.

thanks,

Tim