Grouping Textbox by Year + Category?

[ericp]

I have this report that I'm trying to create where I need to create a chart that breaks down the Total Values by FiscalYear and FundCategory.

In the screenshot, you can see that one of my projects have 2 'FundTypes' that are in the 'FundCategory' of Federal and 'FiscalYear' or 2021. I want to figure out a way to display that into the chart under the FED 2021.

So the total that should display in that cell would be 1200, because it adds both of the FundTypes that have the year 2021 + FundCategory of Federal

[ericp]

Here is my MRT file and datasource.

[Lech Kulikowski]

Hello,

You can add the DataTransformation item with the necessary grouping and calculations and then use it for the Chart.

Thank you.