Calculated fields based on date difference
Hello everyone,
I am currently facing the following problem and would appreciate your support.
Attached you can see the current pivot table I have:
Issue.jpg
I would like to add two calculated fields which bring me the date difference between the 0.4 and 0.3, as well as 0.4 and 0.2.
Your support is extremely appreciated!!
Thanks
Mr. Myr
Last edited by mrmyr; 09-19-2012 at 08:44 AM. Reason: New screenshot
Hi
maybe it would be easier to adapt the data range? Please post a sample sheet with some data and the PT
Here it goes!
Thank you very much!
Last edited by Cutter; 09-19-2012 at 11:45 AM. Reason: Removed whole post quote
you can do it with calculated items but you've gotta format the result cells as numbers instead of dates
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks JosephP!
For an unknown reason, the calculated items function is not enabled in my Excel. Do you know what is wrong?
Thanks again!
you have to select a cell in the column headers before the button is enabled. ridiculous I know but there you go ;-)
Thank you! Worked fine!
Last edited by Cutter; 09-19-2012 at 11:46 AM. Reason: Removed whole post quote
@ mrmyr
Welcome to the forum.
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Thank you! I will make sure to set as solved next time. :-)
Last edited by Cutter; 09-20-2012 at 10:39 AM. Reason: Removed whole post quote
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks