Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

power pivot table

ResolvedVersion 2013

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

Sat 13 Jul 2019: Automatically marked as resolved.

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.