Grouping Textbox by Year + Category?
Posted: Thu Oct 26, 2023 3:46 am
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
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