• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculating in a Pivot Table

Carmen Cruz

New Member
I have a pivot table that I was able to create a calculation, however it is returning a zero value, why? the value is =name/days

Count of NAME Sum of DAYS Sum of LOS
2010 1341 6515 0.00%
2011 1508 6358 0.00%
2012 1431 6211 0.00%
2013 1411 5730 0.00%
2014 1464 6129 0.00%
2015 409 1859 0.00%
Grand Total 7564 32802 0.00%
 
Hi,

Kindly upload sample file with sample raw data. And manually put expected output.

regards,
Prasad
 
Ok, I figured that one out... Can you tell me how do I change my dates to Fiscal year, starting from July 2010 ending in June 2011.. I can do it from quarterly but I need it to show in my chart as FY10-11.
 

Attachments

  • Book1.xlsx
    33.3 KB · Views: 0
Sorry, I did not understand you. :(

Are you looking to show graph with date range July 2010 to June 2011, and monthwise?

Regards,
Prasad DN
 
Back
Top