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.
Currently I have to manually sort and filter the summary page for each section and then remove all the other sections charges from the detailed tab.
I am trying to create the 12 section reports using filters from the main report all in one 'working' folder.
I then hope to name the overall monthly report the same as the main report in the 'working' folder and overwrite the main report.
If everything works then I will save the values of the 12 section reports and distribute them.
(Sorry to be so long winded).
For this report to match the formatting that my boss wanted I have to have a total at the end of column C that moves up and down according to the last populated cell in column C. I am not sure if this can be done.
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 🙂
- 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.