Filter by date in a sub database
Good evening, I would like to know how to filter on a table that uses a subtable. For example, the one that groups the total accounts cannot be filtered by month, or quarter, or year. How can it be done? Thank you
7 replies
-
said:
For example, the one that groups the total accounts cannot be filtered by month, or quarter, or year. How can it be done?First you probably want to create month, quarter and year formula fields in your subtable.
Since you want to show data from a subtable and that subtable will most likely have multiple records you need to figure out which record you want to show in the table view of the main table. So how do you know which record you want to show?
-
I have data in the subtable for 2016, 2017, 2018 and I want it to show me the data for a year, for example 2018.
-
In accounts database, I need to show only amounts of 2016 (from accounting database) for example. I can not filter by year because it is a sub table.
-
said:
What I need is the balance sheet for 2016Is that what the Balance Sheet table for?
can you upload a sample db? it would make it easier to figure out what you want.
Content aside
- 2 mths agoLast active
- 7Replies
- 48Views
-
2
Following