951353 wrote:Once you create the BINS column, take the original column (that housed the type e.g., Expense, Revenue, etc.) out of your query. Put that in the Excluded Section of your pivot table.
The Bins are working correctly, however when I include Expense, Revenue together all the associated line items are also showing up. I do not want the individual line items to show up, instead the Amt Subtotals. Is there a way to supress the individual line items ?