Re: Pulling Sub totals from a Gallery
Ok, for your table is the category Column named Category? Thats what we are referencing here.
Sum(GalleryExpenses.AllItems, If(ThisRecord.CategoryCOLUMN=(Whatevercategory you want), Galcost))
You could also create a drop down of your categories and make the code like this:
Sum(GalleryExpenses.AllItems, If(ThisRecord.Category=DropDown1.Selected.Value,Galcost))