Anupama has attended:
Excel Dashboards for Business Intelligence course
Pivot Tables
I currently extract raw data and run pivot tables for reporting purposes. Every month - when I need to refresh the year to date data, I need to change the formula to incorporate that month.
Is there a way, I can have the formula (within the pivot table - calculated function) point to a cell, so that I can just increase the period by 1 and it will add this to the formula?
RE: Pivot Tables
Hi Anupama,
Thank you for the forum question.
Please send a sample as we talked about yesterday to:
info@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
