Business and Productivity Software
Problem for Business and Productivity Software
Generic problem for all Business and Productivity Sof...

Calculated field in Excel pivot




By Consero on Dec 17, 2007

" "
The Calculated field if used to calculated the difference between 2 fields gives the difference in amount. Is there a way to get the difference in count. The count formula in Calculated field doesn't seem to work. Kindly help

Best Solution

posted on Dec 30, 2007
Very Helpful)

PA8558

Rank: Master 
Rating: 83%, 58 votes
Count will only work with numbers. So select another box where you want your number and use this formula: =count(x:x) This should give the count number then you will need to find the difference. In another box, use =sum(x-x). This should give you your difference.


If this helps you, please rate me. Thanks, Patty
Was this helpful?
Yes
No
1 person thought this was helpful

Popular Solutions for Business and Productivity


Questions and Unsolved Problems for Business and Productivity


Answer
my computer mixed up file type and extension , how to fix it ,,, when I double click on file will... (More)

Answer
When installing Office communicator 2005 on a PC, I get a installation interrupted message. What... (More)

Answer
Having trouble getting datbase formulas to work in MS Works 8.5 In particular I can't get a... (More)

Answer
I just recently got a digi 002 from a friend, I already had the Mbox 2, which works just fine,... (More)


Didn't find what you were looking for?

Describe your problem:

Select a Category:







Ask our Experts

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Browse popular Problems
More Common Problems
Most Common Problems for:
For Business and Productivity...:

Top Business and Pro... Experts

Rank: Guru Guru  

Solutions: 1349
Member Since: July 2009

Experience: I have owned a computer networking sales and service company.

Ask Me
Find more Business and Pro... Experts

Top Computer & Laptop Repair

(877) 934-6198
Send your laptop to us and we will diagnose the...
A+ Rated Oceanside Computer Sales & Service, LLC

(877) 729-0812
We connect to your computer over the Internet to...
Remote Repair


       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

X
Continue
When the original poster rates a solution that was given to his own problem, that rating is locked!
X

Are you sure the solution content is Inappropriate?
   
Tech buddies can communicate directly to answer questions. Become a Tech Buddy and have direct access to your favorite expert for FREE!
Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select