Contrary to popular belief, working on documents online can be trouble-free. Sure, some file formats might seem too hard with which to work. But if you get the right solution, like DocHub, it's easy to edit any document with minimum effort. DocHub is your go-to solution for tasks as simple as the option to Index Sum Notification For Free a single file or something as intimidating as handling a massive pile of complex paperwork.
When considering a tool for online file editing, there are many solutions out there. Yet, not all of them are powerful enough to accommodate the needs of individuals requiring minimum editing capabilities or small businesses that look for more advanced tools that allow them to collaborate within their document-based workflow. DocHub is a multi-purpose solution that makes managing paperwork online more simplified and smoother. Try DocHub now!
in this lecture Im going to show you how to create a dynamic sum thats based on user selection so what we have here is HR data we have a list of cost centers and various HR related information by cross center now we want to create a dashboard type of report where the user can select the parameter they want to see and the formula is going to sum up the values for that cost Center based on the parameter which means that we need to create a sum range thats going to jump columns depending on user selection so lets see how we can sum not just by criteria but also some different columns here what we have is a set of data from the HR department on Khan Center name some additional information salary benefits and bonus and what we want to do is to create a report where we can input the cost center we can select from a drop-down list if we want to see the summed salary benefits or bonus for here Im going to include a data validation select list and my source is going to be these three and
