Forum Discussion
Solved
Pivot table- view first row of item
Hello, I'm new in using Pivot tables, trying to add additional columns to the pivot table and view the information in the first cell of the item: The purpose was to show Item column+Item descripti...
Hi IlonaK2208,
click in the pivot table, and then open menu "Design | Subtotals | Do not Show Subtotals"
If necessary, you could do the same for the grand total line:
"Design | Grand Totals | Off for Rows and Columns"
Kind regards,
Marin
Hi Martin, Thank you for a solution!
When I'm converting view to a column I see duplicated rows with Grand Total under each item row, please advise how I can remove it?
Hi IlonaK2208,
click in the pivot table, and then open menu "Design | Subtotals | Do not Show Subtotals"
If necessary, you could do the same for the grand total line:
"Design | Grand Totals | Off for Rows and Columns"
Kind regards,
Marin
- Great, it works, thanks!