Pivot table - Gross Profit Percentage subtotal with multiple items

C

Cheryl

Hi
I have created a pivot table from an external database to show Gross Profit
and the percentage per Sales Rep and Customer The items Salesperson then
Customer are in the rows and in the column I have months. The data is sales,
costs, gross profit, and gross profit percentage. What is happening in the
grand total column is that the subtotal GP% is sometimes showing 0.00%
instead of the actual percentage. Could someone please let me know who I can
solve this.

Also when there is no sales value against an item I don't want the GP% to be
calculated. I would prefer the field to be blank.


Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
subtotal by a range 4
Pivot Table Help - Gross Margin % & % of Sales 1
Help with organising info 1
gross profit 2
Pivot Table 1
Calculation on Pivot table running totals 0
IIF Function & Calculation 3

Top