Thread
:
Pivot Table Calculated Field- Help
View Single Post
#
2
Faulk
Posts: n/a
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.
Reply With Quote