Good afternoon, I want to add a calculated (date difference) field but don't appear to have the choice under PivotTable Tools; Options; Tools. The only thing under there is PivotChart.
Hi Skip, no. Unfortunately the only thing under the PivotTable Tools; Options; Tools is PivotChart. I don't appear to have an "Analyze" tab. My version is 14.0.7015.1000 (32 bit)
Phew many thanks Skip. An explanation that appears to have been missing from ALL the other explanations , "Fields, Items & Sets ". Genius - well, we know that!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.