This content has been marked as final.
Show 2 replies

1. Re: Apply Labels Only to a Group or a Set?
Walt Reed Nov 4, 2016 11:39 AM (in response to jon rios)Jon,
See attached Workbook. First, you want to create a calculation that takes the WINDOW_MEDIAN(SUM(Price)). Then create another calculated field where if the Sum(Price)>WINDOW_MEDIAN(SUM(Price)) THEN SUM(Price). Then put that field on labels.
Walt

Label_OnlyAboveAverage.twbx 166.5 KB


2. Re: Apply Labels Only to a Group or a Set?
jon rios Nov 28, 2016 8:06 PM (in response to Walt Reed)THANKS Walt
i have been playing with this a bit to try and learn more. your solution works... i am trying different things... why wont,
{ INCLUDE: MEDIAN([Price])} work is the conditional formula, if sum(price) > { INCLUDE: MEDIAN([Price])} then sum(price)