SOLVED

Pivot table- view first row of item

Copper Contributor

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 description+Count of all Series Number+First Serial Number

Please let me know if there is any option to see it with Pivot Table or any other way?

IlonaK2208_0-1688540526775.png

 

 

4 Replies

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"

Martin_Weiss_0-1688569790965.png

But it's not possible to add only the first serial number to that, this is not how Pivot tables work.

 

Kind regards,
Martin

@Martin_Weiss 

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?

best response confirmed by IlonaK2208 (Copper Contributor)
Solution

Hi @IlonaK2208,

 

click in the pivot table, and then open menu "Design | Subtotals | Do not Show Subtotals"

Martin_Weiss_0-1688631489554.png

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!
1 best response

Accepted Solutions
best response confirmed by IlonaK2208 (Copper Contributor)
Solution

Hi @IlonaK2208,

 

click in the pivot table, and then open menu "Design | Subtotals | Do not Show Subtotals"

Martin_Weiss_0-1688631489554.png

If necessary, you could do the same for the grand total line:

"Design | Grand Totals | Off for Rows and Columns"

 

Kind regards,

Marin

View solution in original post