Tsudoi has attended:
Excel PowerPivot course
Excel VBA Introduction course
Power Pivot table
Hi,
Please can you help me understand how to do following?
In Year column I have 2015, 2016...etc
In Sales column I have sales data.
I can calculate a measure to show YoY growth % but then when I pivot a table, I don’t want to show 100% in the 2017 column.
I only want to show 2017 Sales, 2018 Sales and YoY Growth % in next column.
Please how can I do that…?
Thanks,
RE: Power Pivot table
Hi Tsudoi,
I hope you are fine and thank you for the forum question.
I would probably be easier for me to help you if I see the file or if you could create a small dummy version.
If you send it to:
info@stl-training.co.uk
I will have time during the weekend to have a look at it.
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
RE: Power Pivot table
Thanks Jens.
I've just sent the dummy sample file.
Thanks,
RE: Power Pivot table
Hi Tsudoi,
I have sent you and email with the answer.
Have a great Saturday.
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