Forum Discussion
Pivot table- view first row of item
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 IlonaK2208
you can add the item description, just pull the field in the Rows area.
Then change the layout of the pivot table in "Design | Report Layout | Show in Table Form"
But it's not possible to add only the first serial number to that, this is not how Pivot tables work.
Kind regards,
Martin
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!
