# Filtering finances by year **URL:** \ **Category:** Get Help\ **Created:** [December 24, 2024, 9:44am UTC](https://community.fibery.io/t/filtering-finances-by-year/8014 "2024-12-24T09:44:22Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [December 24, 2024, 9:44am UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/1 "2024-12-24T09:44:23Z")
I’m using the fibery finance table. I want to create a view for the transactions by category The easiest way would be to filter the transactions by their date, but because the lookup of the categories happens on the back end and not related to the filtered view, this data isn’t related to the view. Thought of adding this as a feature request, but it changes a lot of fundimentals about the lookup. So I’m wondering if there’s another work around? Thanks! ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [December 24, 2024, 9:59am UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/2 "2024-12-24T09:59:36Z")
Not sure I understand everything you’re saying. > [@RonMakesSystems](#): > > the fibery finance table what is this? > [@RonMakesSystems](#): > > because the lookup of the categories happens on the back end and not related to the filtered view, this data isn’t related to the view. Can you explain a bit more what you mean by this. Maybe some screenshots would help… ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [December 24, 2024, 12:13pm UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/3 "2024-12-24T12:13:32Z")
Sorry I wrote this on the bus. I meant the fibery finance template. See screenshot. ![Screenshot_20241224-121118](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/5/527964d8ecf5fdd297b73f989c7d9fb5e7994a54.png) The category sum is calculated on the backend. No matter how I filter the front-end. I want to make a view just for 2024. Then a new one for 2025. Or is there any other way to get the annual accounts? Report maybe? I want to be able to get a report year by year. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [December 24, 2024, 12:27pm UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/4 "2024-12-24T12:27:27Z")
> [@RonMakesSystems](#): > > The category sum is calculated on the backend. No matter how I filter the front-end. The view you shared is for the (current) balance for each account by category. What would it mean to calculate this for a specific year? Do you just want to see the total of incoming and outgoing transactions for a given year? Or do you want to see the balance on 31st December of each year? ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [December 24, 2024, 12:45pm UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/5 "2024-12-24T12:45:35Z")
> [@Chr1sG](#): > > Do you just want to see the total of incoming and outgoing transactions for a given year? This one. My solution would be to filter the transactions by date. But this doesn’t effect the sum of the category. Edit: nvm there’s no transactions in the view I showed you’re right. But the look up totals are from related transactions that are dated. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [December 24, 2024, 2:13pm UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/6 "2024-12-24T14:13:24Z")
I suggest making a report view (table), based on Transactions, with a column that is this: ```auto IF( SPLIT( [Encoding], '|' ) == '>', [From account], [To account] ) ``` and another column which is this: ```auto SUM( IF( SPLIT( [Encoding], '|' ) == '>', -[Amount], [Amount] ) ) ``` Then you can group by date, aggregated by year (make sure you check the ‘Show subtotal’ box): ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/d8b14f6108bc559bcc14086d5f5610d888548fd1.png) It should get you something like this: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b09093918cf5ed054c4dae0732fdfdf13288932b.png) Each account shows the subtotal of all incoming/outgoing transactions for each year ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [February 12, 2025, 12:05pm UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/7 "2025-02-12T12:05:38Z")
Hey! I’m just getting to making this now. This works for some reason but I’m so confused as to why… (Nevermind just found this: [https://www.youtube.com/watch?v=sK2RTuQZdmI](https://www.youtube.com/watch?v=sK2RTuQZdmI)) I want to show the parent account and category for each one as well. Is there a way to do that as well? I’m getting it slowly. Is it possible to do recursive parent in report view? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [February 12, 2025, 5:27pm UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/8 "2025-02-12T17:27:59Z")
> [@RonMakesSystems](#): > > Is it possible to do recursive parent in report view? You can make a recursive formula field which gets the very top level parent, but there is no syntax for doing that in report view. ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [February 13, 2025, 7:13pm UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/9 "2025-02-13T19:13:17Z")
Okay makes sense. Lets stick to top level for now them. I tried to group like this: IF( SPLIT( [Encoding], ‘|’ ) == ‘\>’, [From top level category], [To top level category] ) But for some reason some entities are in no group at all. In the source data it shows its empty. But when I go into the entity it does in actuality have a parent to account (and all the related formulas). I suspect something weird is happening when spliting the data? Some data is lost maybe? I am not sure. I sat on this yesterday all day haha. ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [February 16, 2025, 8:48am UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/10 "2025-02-16T08:48:14Z")
After 2 days of tinkering, turns out that when I make the report on “historical data”, not all the data comes through… Not at all sure why, if this intended or a bug? I set it to Current data, used the group formula above, and now it works like a charm. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [February 16, 2025, 9:28am UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/11 "2025-02-16T09:28:38Z")
If, after reading [the guide on historical reports](https://the.fibery.io/@public/User_Guide/Guide/Historical-and-Cumulative-Reports-59#Guide/Current-vs-Historical-Data-in-Reports-168) and [the guide to context views](https://the.fibery.io/@public/User_Guide/Guide/Context-Views-20), you think some data is incorrectly missing from your report, let us know. ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [February 16, 2025, 3:20pm UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/12 "2025-02-16T15:20:28Z")
Thanks Chris. Still all the reporting capabilities. I’m looking into it more now. The thing is, the historical view doesn’t have a filter on, so I expect (incorrectly?) that is it all data and should be the same as current data. I see that actually the data for the account is there, but the formulas that find the category of the account is missing (on some of the data, not all of it). Not sure exactly… In any case, now I understand the use case for historical data. It could be a good way to go about reporting if the transactions were live integrated into the account, but since we only update it once in a while, it would not be accurate info from what I understand. Thanks Chris! ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [February 16, 2025, 3:26pm UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/13 "2025-02-16T15:26:53Z")
> [@RonMakesSystems](#): > > I expect (incorrectly?) that is it all data and should be the same as current data. I see that actually the data for the account is there, but the formulas that find the category of the account is missing (on some of the data, not all of it). Not sure exactly The data in the historical report will not be ‘the same’ as the current data but rather will be a collection of data points over the lifetime of the entities (which means it can be considered a superset of the current data). If you add a formula field, the calculated value of that field will not exist for all data points (events) in the historical report. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [April 29, 2025, 11:30am UTC](https://community.fibery.io/t/filtering-finances-by-year/8014/14 "2025-04-29T11:30:30Z")