How do I remove the subtotal groupings within a pivot table and only display the final totals.
R Rose Dec 27, 2007 #1 How do I remove the subtotal groupings within a pivot table and only display the final totals.
M Michel Walsh Jan 8, 2008 #2 Have you tired to group by on a constant, something like (in SQL view): TRANSFROM SUM(somefield) SELECT "All" FROM tableName GROUP BY "All" PIVOT someFieldOrExpression Vanderghast, Access MVP
Have you tired to group by on a constant, something like (in SQL view): TRANSFROM SUM(somefield) SELECT "All" FROM tableName GROUP BY "All" PIVOT someFieldOrExpression Vanderghast, Access MVP
