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!
Solved! 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...
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...
User | Count |
---|---|
123 | |
90 | |
88 | |
75 | |
66 |
User | Count |
---|---|
219 | |
179 | |
138 | |
95 | |
72 |