Solved

Formula not working in pivot table

Posted on 2014-01-14
3
314 Views
Last Modified: 2014-01-15
I want to create a pivottable with the following values :

Column:
Number of days. This field is called "TEMPS"

Rows:
Row 1:
count of the datacolumn "AUDIT". This was very simple; I put the field "AUDIT" in the values and change it to count numbers instead of sum in value field settings. This is simply a count of all the different values.

Row 2:
Here I'm using a formula. I want to calculate the value in TEMPS with the value of row 1: Number of Days * count of Audit. For that I created a simple formula: count(AUDIT)*TEMPS. I called this formula "DAYS". It calculates correctly.

Now I want to a a third row that divides Row 2/Row 1.

When I try now to add a formula: DAYS/count(AUDIT) it does not work.

I have even tried the simple formula count(AUDIT), wich I think should give the same result as Row 1, but gives me always the number 1

Are there any suggestions ?

Steven
0
Comment
Question by:Steven Vermoere
3 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39779286
Hi,

Could you send a sample?

Regards
0
 
LVL 32

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 39779336
Mathematically, your formula DAYS / COUNT(Audit) will give the same result as TEMPS.

DAYS = COUNT(Audit) * TEMPS

Therefore

DAYS / COUNT(Audit) = TEMPS

What are you aiming to achieve, I guess it isn't just another row with the same data?

Thanks
Rob H
0
 

Author Closing Comment

by:Steven Vermoere
ID: 39782055
Yes Rob,

You are completely right. The people asking me to create the pivottable have found out the same solution after you told me that I was also asking something that is already available.

Sorry for the bother

Steven
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now