Group and Filter Chart Data

[aadilganie]

Hi,

I am trying to show users a chart breakdown of their expenses by item type & total (sum) and filtered by their BudgetID.

I have managed to get the item type grouped but the chart now shows the series and lables as item type. How do I add the filter by budget ID and the total to the chart?

This is what I have so far:

GroupBy('Budget Management Details',"Item_x0020_Type_x0020_Text", "Item Type")

I know I may have to use the AddColumns function but keep getting the syntax incorrect.

Please assist!

[aadilganie · Accepted solution]

I think I have managed to figure it out with the following:

AddColumns(GroupBy(Filter('Budget Management Details',Budget_x0020_ID_x0020_Text = varLastID),"Item_x0020_Type_x0020_Text","Budget_x0020_ID_x0020_Text","ItemGroup"),"varTotal",Sum(ItemGroup,Total)),Budget_x0020_ID_x0020_Text)

Have had to add lookup columns as Text columns in the child list as could not read lookup columns in the group by. Not sure if there is a way aroun this...