Pivot table for formula
 

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

Pivot table for formula
 

Hi,

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

Thanks
Xcelion


"d.amalia" wrote:

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

Pivot table for formula
 

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.

d.amalia wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html