
1. Re: Fixed by one dimension, if at least one sub dimension = something, then assign fixed dimension....
maneesh.gaddam Oct 11, 2018 10:33 AM (in response to Raza Asghar)1 of 1 people found this helpfulRaza,
You can try the following
Calculation 1: {FIXED DisplayLocn: MAX(if Aging='Y' then [Item ID] END)}
Calculation 2: IIF(ISNULL(Calculation1),'NON AGING','AGING')

2. Re: Fixed by one dimension, if at least one sub dimension = something, then assign fixed dimension....
Raza Asghar Oct 11, 2018 10:42 AM (in response to Raza Asghar)Thank you, so prompt!

3. Re: Fixed by one dimension, if at least one sub dimension = something, then assign fixed dimension....
Raza Asghar Oct 11, 2018 2:14 PM (in response to Raza Asghar)Can you explain how these 2 calculated fields work? Step by step? I am having trouble understanding how it's doing it. If you could walk through how the calculated fields work for each display locn in the table, I'd really appreciate that.
Thank you!!

4. Re: Fixed by one dimension, if at least one sub dimension = something, then assign fixed dimension....
maneesh.gaddam Oct 11, 2018 4:04 PM (in response to Raza Asghar)First calculation: Tableau pulls, for each Display Location, Maximum of ID where Aging=Y. Here, it doesn't matter if we take Max or Min as your requirement only considers scenarios with Aging=Y. I just took Max for my reference. So, for [Display Locations], which have an Aging=Y, it takes Max ID and for other locations with no Aging=Y, it gives NULL.
Second Calculation: It is just saying, if first calculation is NULL then it doesn't have any Aging=Y record and if it isn't NULL, it does have a record so assign 'Aging'.
Hope this make sense.

5. Re: Fixed by one dimension, if at least one sub dimension = something, then assign fixed dimension....
Raza Asghar Oct 31, 2018 10:20 AM (in response to maneesh.gaddam)How would I perform the same logic but in this case I would want to know if a Display LOCN has all "Y"s for AGING, not just AT LEAST 1.
In this case, it would only spit out "AGING" for Display Locn 1005 and not the other ones, since Display Locn 1005 has all "Y".
Thanks.

6. Re: Fixed by one dimension, if at least one sub dimension = something, then assign fixed dimension....
maneesh.gaddam Oct 31, 2018 10:37 AM (in response to Raza Asghar)You can try
IF {FIXED DisplayLocn: MIN(Aging)}='N' 'Not Aging' Else 'Aging' END