This content has been marked as final.
Show 4 replies
-
1. Re: Group and sorted display of Set data (Workout Wednesday week 41)
Ken FlerlageOct 12, 2019 11:28 AM (in response to Sumati Gaur)
-
2. Re: Group and sorted display of Set data (Workout Wednesday week 41)
Ken FlerlageOct 12, 2019 11:32 AM (in response to Ken Flerlage)
I just looked at the WW site and think I see what you mean now--are you asking how you can total up those selected items into just one single "Cohort" item? If so, try creating a calculated field like this:
Customer or Cohort
// If in the set, condense into "Cohort". Else customer name. IF [Top Customers by Profit] THEN "Cohort" ELSE [Customer Name] END
Then build your table like this:
Then turn off the header for IN/OUT.
-
3. Re: Group and sorted display of Set data (Workout Wednesday week 41)
Sumati Gaur Oct 15, 2019 7:20 AM (in response to Ken Flerlage)Hi Ken Flerlage .Thanks a lot. This was exactly what i was stuck with. Its working for me now
-
4. Re: Group and sorted display of Set data (Workout Wednesday week 41)
Ken FlerlageOct 15, 2019 7:25 AM (in response to Sumati Gaur)
Great. Glad to hear it!