I have data of sales in multiple cities. I need to see the effects on the mean and stdev of sales if you exclude each city. Attached a sample workflow that filters out each city and then finds the mean and stdev. In the example there are only three cities. In the actual data, the number of cities is large and is not fixed. In the example, there is also a macro that does the same thing to make it dynamic. Is there any way to make it dynamic without building a macro that filters out each city then calculate the mean and stdev? I don't want to use a macro for performance concerns since I have a large number of cities and I don't want the workflow to do cities one by one. I thought if there is a way where you can group by city, and then do the mean and stdev, not for each city, but for all cities except each, if that makes sense.
Solved! Go to Solution.
@BenMoss thanks for the solution
Hi @ahmedalra , if this resolves your issue can you please mark this post as an accepted solution, not only will that help me catch @jdunkerley79 but it will also help priortize this search result should others have a similar issue in the future.
Ben