Power Pivot table

Resolved · Medium Priority · Version 2013

Thu 4 Jul 2019, 19:00 Delegate Tsudoi said...

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,

Thu 4 Jul 2019, 20:05 Trainer Jens said...

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

Fri 5 Jul 2019, 08:19 Delegate Tsudoi said...

RE: Power Pivot table

Thanks Jens.
I've just sent the dummy sample file.
Thanks,

Sat 6 Jul 2019, 11:17 Trainer Jens said...

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.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips