Count Specific Values in Pivot

K

kastalarial

New Member
Joined
Jun 12, 2015
Messages
1
Hi, how do I make my Pivot Count "Qualified or Unqualified" only rather than counting all values it sees?

33c3au0.png
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
When you apply the filter it doesn't adjust the count? What does your source data look like?
 
Upvote 0
Could just drag the "QA Remarks" field into the row labels below "Agent Name"...
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Count Pivot with Named-Range
Replies
2
Views
120
JcBoulay
J
D
  • Question
Pivot table counts inaccurate
Replies
2
Views
2K
dd14
D
V
  • Question
Advanced Pivot to Identify SAME text in multiple columns
Replies
1
Views
251
alansidman
alansidman
S
  • Question
how to transpose cell values with column headers
Replies
3
Views
219
Peter_SSs
Peter_SSs
L
  • Question
Multiple value filters in pivot table
Replies
0
Views
936
Lulu1000
L

Forum statistics

Threads
1,202,908
Messages
6,052,485
Members
444,587
Latest member
ezza59

Share this page

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