Calculating in a Pivot Table

[Carmen Cruz]

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%

 

[Carmen Cruz]

please

 

[prasaddn]

Hi,

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

regards,
Prasad

 

[Carmen Cruz]

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.

 

[prasaddn]

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

 

[David Evans]

Take a look at http://www.contextures.com/fiscalyearcalculations.html