View Single Post
  #2   Report Post  
Faulk
 
Posts: n/a
Default

Try adding a column to your data called "Allow/Deny" and use the
following formula:

Assuming Name is column A and Credit is column B, in column C type:

=if(B1<5,"Deny","Allow")

Then add the third column to your pivot table.