Solved

Formula not working in pivot table

Posted on 2014-01-14
3
328 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 50

Expert Comment

by:Rgonzo1971
ID: 39779286
Hi,

Could you send a sample?

Regards
0
 
LVL 33

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

821 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