Custom Dashboard requirement to get Multiple Columns and Grouping Net Difference.

Summary:

We are working on Custom Dashboard Requirements for list view for business user which are below requirements:1. We are trying to get Net Difference amount in dashboard along with some other attributes, we are trying to group multiple rows in dashboard which has same attribute details like by legal entity, but dashboard is showing each row for each reconciliation ID. So how can we group by those rows with similar details.2. Along with above we are trying  to get  net differences in Custom Dashboard as separate columns along with other details. Example if user gives period range in parameter like