Pivot table for formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi,

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

Thanks
Xcelion
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Average of Subtotals in Pivot Table 0
Pivot Table Calculations 2
Pivot Table Defaults 1
Pivot table filed defaults 2
Pivot Table Field based on two data area fields 3
Pivot Table Calculate Field 1
Calculated field in a pivot table? 3

Back
Top