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.
Go to 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...
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.