Filtered data (sourced from one sheet) on different sheets.

Discuss the spreadsheet application

Filtered data (sourced from one sheet) on different sheets.

Postby avaizhashmi » Sat Dec 01, 2018 10:27 pm

I am developing a sheet system for my accounts.

I have raw CSV data on one sheet. I will keep pasting more data here as time goes on.
I am recalling? the data on other sheets using =$Accounts_RAW_DATA.A3

I am aiming for a rather dynamic filtering system so that if I am on my Chequing Account for ABC bank, only those transaction with "Chequing ABC Bank" value would show up and not the others. And the math would follow from there.

I think filtering system is not changing the sum of transactions automatically as the rows are just hidden.

Please give me a few pointers.
OpenOffice 4.1.3 on macOS Sierra 10.12.6 (16G1510)
avaizhashmi
 
Posts: 11
Joined: Sun Nov 25, 2018 2:32 am

Re: Filtered data (sourced from one sheet) on different shee

Postby RusselB » Sat Dec 01, 2018 10:44 pm

Please upload a sample of your CSV or your spreadsheet so that we can look at the layout. Some dummy data would also be helpful.
Without that information, I'd be taking wild shots in the dark as to how you could do this, as some of the methods I'm thinking of require certain information to be located in certain locations.
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: 4926
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Filtered data (sourced from one sheet) on different shee

Postby avaizhashmi » Sun Dec 02, 2018 1:04 am

Here and thanx :)
Attachments
DataOnMultipleSheets.ods
(61.71 KiB) Downloaded 12 times
OpenOffice 4.1.3 on macOS Sierra 10.12.6 (16G1510)
avaizhashmi
 
Posts: 11
Joined: Sun Nov 25, 2018 2:32 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests