Can we create an Dashboard to show Budget based on department

Summary:

We have a Requirement to create a Dashboard based on which CEO to see recommendations by Department vs budget.

E.g Manager 1

2 Direct reportees with different department

Recommended amount based on department vs Total Budget

Can we achieve using any filter criteria?

Any leads will be highly appreciated

Regards

Manisha

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):