I subtotaled (sum) on 3 columns based on changes in a 4th column. There is a
5th column (repeating text info in all cells in the subtotaled groups) that I
want to display in the subtotaled (level 2) row. How do I get it to show?
I subtotaled (sum) on 3 columns based on changes in a 4th column. There is a
5th column (repeating text info in all cells in the subtotaled groups) that I
want to display in the subtotaled (level 2) row. How do I get it to show?
Hi
Go to Data/Subtotals again and select the subtotal requirement. Make sure
you uncheck 'Replace current subtotals' before you click OK.
Andy.
"grjk" <grjk@discussions.microsoft.com> wrote in message
news:00B05D9E-E674-4628-9BD1-59DFAEF4D1EE@microsoft.com...
>I subtotaled (sum) on 3 columns based on changes in a 4th column. There is
>a
> 5th column (repeating text info in all cells in the subtotaled groups)
> that I
> want to display in the subtotaled (level 2) row. How do I get it to show?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks