an IF function can not compare groupings in tableau. your [This Year Net] field becomes aggregation because it is a relational data source ...
you could share the columns in your data source I think you could fix it from the data source without having to make a relationship in the worksheets .
Thank you Pablo,
I am not sure exactly what you mean by sharing the columns in the data source. Can you help me understand that a little better?
Sry John, I was at lunch...
I understand that you relationship between sources of information is with the fields "Account Executive Name" and "Market"... My proposal is to have a single source of data and that you do not have to do the relationship within the spreadsheet....
Expectation: (Only One)
in this way your field "[This Year Net]" would not be an aggregation and you could call it in the IF funtion.
Unfortunately I can not create one data source out of these, unless you are referring to blending the data with tableau?
I understand what you are saying, I am not sure that I am able to do that.
I tried this: (IF ATTR([Stage Name])="Closed - Booked" and ATTR([Type]) = "Existing Business" THEN SUM([Pacing].[This Year (Net)]) END)
but when I do that, it does not return a "This Year" value.
Any thoughts on this route?