This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I had posted this question yesterday, but couldn't readily try out the offered solution, and have now realized that it would not work. I'll try to give more detail in this post.
I'm trying to find a way to replicate a For Each loop. I need to be able to take the average of the volume for specific members for each as of date, and display this average for all member statuses. However, member statuses other than "Member" will not be included in the average.
For Each as of date
If Plan = 1 and Member Status = Member, then Average(volume)
If Plan = 2 and Member Status = Member, then Average(volume)
Next as of date
I don't believe a simple summarize would work, unless I can request the specific members within the summarize somehow. I have attached a simple sample of how I want the end product to look.