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
Try this: [CY PAX] + {SUM(IF [WEEK ENDING] = DATE("2018-08-04") THEN [CY NET WEEKLY PAX] END)}
Become a Viz Whiz on the Forums! Support the Community and master Tableau.