Pivot table to show % of particular item in Row

**jp16** · 05-17-2018, 06:44 AM

Hi, in my data. There is a type (Sales or Cost), the salesman name and the amount. However, i need to know the % of Sales/Total Sales. Is this possible?
Please see attached.

**xlnitwit** · 05-17-2018, 06:47 AM

You cannot have the subtotal perform a different calculation, or use a different display. You could create a different calculation with Power Pivot, but not an automatically adjusting different number format.

**jp16** · 05-17-2018, 07:01 AM

is there any way i can achieve it by adding more column in my data?

**xlnitwit** · 05-17-2018, 07:06 AM

In your data, no. In your pivot table, yes - simply repeat the field and change the 'Show Values as' as needed.

Pivot table to show % of particular item in Row

LinkBack

Thread Tools

Rate This Thread

Display

Pivot table to show % of particular item in Row

Re: Pivot table to show % of particular item in Row

Re: Pivot table to show % of particular item in Row

Re: Pivot table to show % of particular item in Row

Thread Information

Users Browsing this Thread

Similar Threads

For each pivot item in pivot table - for data model

Pivot table to show years each item appeared

[SOLVED] Creating a formula in a pivot table while using another calculated item in the pivot

VBA Pivot Table: Problem with pivot item visibility

[NOT POSSIBLE] Pivot table with calculated item to show only categories > 0

Pivot Chart - Hide other items when show detail on one item

pivot table - need to go to specific cell after selecting a item in pivot table

Bookmarks

Bookmarks

Posting Permissions