Pivot table for formula

D

d.amalia

Dear All,

How could i create formula from data that i produce in pivot table.
For example : i want to know REMAINING C-MODULE from count STATUS and count
DOCUMENT RECEIVED.
They always apply as "sum", can i change ito count...??

//Dian
 
X

Xcelion

Hi,

Right click on the Pivot Table take Field Setting and change it to count

Thanks
Xcelion
 
D

Debra Dalgleish

In the formula, the underlying values will be summed. If you want to use
a count, you can add a column to the source table, and enter a 1 in each
row.

In the pivot table, use that column in the formula -- its sum will be
equal to the count of items.
 
Top