ignore zeros pivot table

  1. C

    Ignore zero values in pivot chart

    Hi there, Background: I have a data set for a call centre that displays each staff member's daily call numbers across two different call types (Call Type 1, Call Type 2) - staff only work on one particular call type each day. I would like to create two pivot charts, one with...
    • cazzzac
    • Thread
    • ignore zeros ignore zeros pivot table pivot chart
    • Replies: 9
    • Forum: Excel Questions
  2. R

    List all values in a table excluding zeros

    Hi everyone I'm not sure how to explain this properly so my apologies if I don't. Please feel free to ask for clarification if you might be able to help. I have a table from a report that's generated by a program we use in this office that lists all sales made by sales people. The columns...
    • Rusty315
    • Thread
    • array formula ignore zeros pivot table pivot table
    • Replies: 7
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top