Hi. I am working on a dashboard and want to give users a tile that shows a category with the highest value. To be a bit more clear, users log expenses and tie them to a set of categories (stored as an option set) and I’d like this dashboard tile to display the name of the category where the majority of expenses are going. This would mean totalling up each item’s cost, sorting by category and identifying which category has the highest number. My math and programming skills are not good enough for this.
Does anyone have an idea as to how I might go about this? Thanks.