Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Kindly find the attached Application.
I hope it will help you.
!
Hi ,
PFA updated File.
I would like to wish everyone a Happy, Healthy and Prosperous New Year 2018.
Thanks & Wish you the same.
Dear Mohammed Mukram
Is there a better way as one needs to hard code the year (2012, 2013 ... 2017 ) in future ?.
Thank you
Tracy
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;
Hi,
Kindly find the Updated attached Application.
Dear Mr Shivesh Singh
Happy New Year 2018
You are using straight table, please advise how to change to pivot table ?.
Thank you
Tracy
Hi
check out if this helps.
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