Need help creating Profit/loss summary

Discuss the spreadsheet application

Need help creating Profit/loss summary

Postby Hass1 » Wed Jan 23, 2019 5:12 am

Hi everybody

I have spent couple of days searching and trying, but couldn't achieve my goal.
It will be extremely helpful if anyone can explain me how to create or create template for me according to my requirement.
Sorry I am not expert in formulas. :ucrazy:

>>we assign "stock number" to each product.
>>incomes and expenses of each stock are mentioned in same column as " stock number".
>>in a separate sheet, I created Profit/Loss summary for each unit separately.

Target : I would like to just type "stock number" and all related incomes and expenses appear in profit/Loss summary Automatically.
This is what I want to do.

profit loss issue.jpg


profit loss summary screenshot.jpg


Please help

Thank you
OpenOffice 4.1.1
Windows 7 Professional 64-bit
Hass1
 
Posts: 3
Joined: Wed Jan 23, 2019 4:33 am

Re: Need help creating Profit/loss summary

Postby RusselB » Wed Jan 23, 2019 8:24 am

Welcome to the Forums.
Regretfully, on my machine at least, your pictures are too small to be of any real use.
You obviously found how to attach a file, so I'm going to ask that you attach your actual working spreadsheet. Anonymize the data if you feel the data is sensitive.
Please note that there is a 128 k file size limit on the forum. If your file is bigger than that, then please upload it to a file sharing service, like Dropbox, MediaFire or Google Drive.
If you upload it to a sharing service, post a link to the file so that we can actually see what you are working with.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4872
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Need help creating Profit/loss summary

Postby Hass1 » Thu Jan 24, 2019 11:41 pm

RusselB wrote:Welcome to the Forums.
Regretfully, on my machine at least, your pictures are too small to be of any real use.
You obviously found how to attach a file, so I'm going to ask that you attach your actual working spreadsheet. Anonymize the data if you feel the data is sensitive.
Please note that there is a 128 k file size limit on the forum. If your file is bigger than that, then please upload it to a file sharing service, like Dropbox, MediaFire or Google Drive.
If you upload it to a sharing service, post a link to the file so that we can actually see what you are working with.


Hi @"RusselB"
Thank you very much for taking out time to write that message.
I had hard time reducing image size (in KBs) but keeping it as a bigger picture.
So finally I uploaded ODS file to sharing server and link is mentioned below.

https://1drv.ms/x/s!Aj93trc7rvY6gREpfIccNe__sQKQ

I will be greatly thankful for the favor to solve my issue.

Thank you

Best Regards
OpenOffice 4.1.1
Windows 7 Professional 64-bit
Hass1
 
Posts: 3
Joined: Wed Jan 23, 2019 4:33 am

Re: Need help creating Profit/loss summary

Postby Hass1 » Sat Feb 09, 2019 1:04 am

Hello Everybody,
Good day

Can Anyone please help with above request?
It will be so nice of you.

Thank you
OpenOffice 4.1.1
Windows 7 Professional 64-bit
Hass1
 
Posts: 3
Joined: Wed Jan 23, 2019 4:33 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests