Change in value

[tracycrown]

Dear all

Kindly advise how to create a report to show change in value for all years.

Data Source:

Description	2011	2012	2013
Revenue	$ 200,000	$            231,400	$              156,822
Cost of sales	$ 140,000	$            161,980	$              109,775
Gross profit	$ 60,000	$              69,420	$                47,047

Requirement :

Description	2012	2011	Change	2013	2012	Change
Revenue	$ 231,400	$    200,000	$       31,400	$ 156,822	$    231,400	$    (74,578)
Cost of sales	$ 161,980	$    140,000	$       21,980	$ 109,775	$    161,980	$    (52,205)
Gross profit	$ 69,420	$ 60,000	$ 9,420	$ 47,047	$ 69,420	$ (22,373)

Thank you

Tracy

[tracycrown]

Dear all,

I do not expect any response on new year day but I would like to wish everyone a Happy, Healthy and Prosperous New Year 2018.

Best Wishes

Tracy

[mdmukramali]

Hi,

Kindly find the attached Application.

I hope it will help you.

!

[mdmukramali]

Hi ,

PFA updated File.

I would like to wish everyone a Happy, Healthy and Prosperous New Year 2018.

            Thanks & Wish you the same.

[tracycrown]

Dear Mohammed Mukram

Is there a better way as one needs to hard code the year (2012, 2013 ... 2017 ) in future ?.

Thank you

Tracy

[shiveshsingh]

Happy new year to you too..please refer attached

test:

CrossTable(Year, Value)

LOAD Description,

    [2011], [2012],

    [2013]

FROM

[..\Desktop\Test-1.xls]

(biff, embedded labels, table is Financial$);

load

Description,Year,Value,if(Description=Previous(Description),Previous(Value),0) as Previuos_Old,

Previous(Value)

Resident test;

[mdmukramali]

Hi,

Kindly find the Updated attached Application.

[tracycrown]

Dear Mr Shivesh Singh

Happy New Year 2018

You are using straight table, please advise how to change to pivot table ?.

Thank you

Tracy

[pradosh_thakur · Accepted solution]

Hi

check out if this helps.

[tracycrown]

Dear Mr Pradosh Thakur

Happy New Year 2018 to you and your family.

Thank you for your kind advice, please advise what is the purpose of INLINE below :

LOAD * INLINE [
DIM
1
2];

Thank You

Tracy