Display list items with non-zero values for sub-list creation

AlexGSG

How would you go about creating a Module that looks in other Modules and finds every item in a list that has any non-zero values entered in a given 12 month period?

 

The idea would be to create a table that shows, for a given group of lists, all combinations of those list items that have at least one non-zero value in the 12-month period. We'd then take that view and use it to make sub-lists, saving us space in our final export module.

 

Let me know if that makes sense, happy to answer questions and open to simpler ways of doing this than the above proposal 🙂