Showing Sales Trend In Pivot Table

**Statz** · 10-12-2017, 03:08 PM

I have a table of data. Column H represents 2017 sales data. Column I represents 2016 sales data. Column K is the difference %.

For example, if Row 2 shows 41.34 for 2017 & 25.26 for 2016 that is a diff % of 63.66% (41.34-25.26)/25.26=63.66

I need to be able to incorporate that in the values pivot table so. I tried googling instructions but's not working.

I have two screen shots to show where I'm at.

Thanks

**Syrkrasi** · 10-12-2017, 04:23 PM

Here is what I have (if I am understanding your request)

I left your calculation as is. So for the Pivot table

Pivot table > Report Layout > Show in Tabular Form

In my sample
ROWS
- Item
- 2017
- 2016

Values
- Difference

Value Field Settings
- Summarize value field by: SUM
- Number Format: Percentage | Decimal Places: 2

See attachment

**Statz** · 10-12-2017, 05:02 PM

^^^ Thanks for the help.

I wish I could upload the file but it's larger than 1 MB. I see your example but I can't get it to work. How do I get to "pivot table > report layout > show in tabular form

Thanks

**Syrkrasi** · 10-13-2017, 09:58 AM

You're welcome and thanks for the rep.

"I wish I could upload the file but it's larger than 1 MB."
Will it be over the size limit if you compress (zip) it?

"I see your example but I can't get it to work. How do I get to "pivot table > report layout > show in tabular form

Click on the any of the pivot table headers. This will make the PIVOTTABLE TOOLS menu appear with two menu tabs.
Click on the DESIGN tab
Within the DESIGN tab, click on the button title REPORT LAYOUT, then click on SHOW IN TABULAR FORM

See image below
Showing Sales Trend In Pivot Table.jpg

From here, you will need to configure the look for your needs.

my suggestions would be to

Hide/filter blanks by clicking on the filter of the first header field of the pivot table.
Remove SUBTOTAL from every header by right-clicking on the header then uncheck Subtotal [Field name]

See image below