Forum Discussion
Dynamic sum of filter formula
GraemeSS You are making it more complicated if you insist on showing the total at the bottom, if you do not have the VSTACK and HSTACK functions that Harun24HR used. If you can convince your boss to move the total to the top of the report (which would be my preferred lay-out), everything will be done very easily. I created a working example in your file. Select the cluster you want the report for from the dropdown in A1 and all will update dynamically.
GraemeSS You are making it more complicated if you insist on showing the total at the bottom, if you do not have the VSTACK and HSTACK functions that Harun24HR used. If you can convince your boss to move the total to the top of the report (which would be my preferred lay-out), everything will be done very easily. I created a working example in your file. Select the cluster you want the report for from the dropdown in A1 and all will update dynamically.
- Riny_van_Eekelen Thank you again. I intended to mark your response as the accepted solution but being a newb I accidentally selected my reply. I can't see a way of undoing it but if someone can tell me I will change it.
Thank you to Harun24HR as well. Apologies for not articulating the problem more clearly.GraemeSS I could "unmark" your answer. Try again 🙂
- Done! Thanks, it did not come up as an option until I went back into the thread from the beginning. 🙂
- Riny_van_Eekelen Thank you! Yes I agree, my boss is pretty set in her ways but this really makes sense. I will try to work it this way. I have also asked for my work to allow me to have access to the VSTACK and HSTACK functions.