In my budget wiki, I have month, category and subcategory tiddlers with debit, credit fields.
credit field has <$list filter="[month<currentRecord>input_type[credit]get[amount]sum[]]"/>
debit field has <$list filter="[month<currentRecord>input_type[debit]get[amount]sum[]]"/>
Also there are input tiddlers with fields like amount, input_type, month, category, subcategory etc.
In the month tiddler, I want to show the percentage of expense under each category and subcategory for that particular month tiddler. How to do it ?
For example, consider the month tiddler May2022
. All the petrol related tiddler in the month of May2022 will have the following fields
-
amount
which will be manually filled. -
category
which will beCar
-
subcategory
which will beFuel
-
month
which will beMay2022
-
input_type
which will bedebit
Now in the May2022 tiddler I want to show the percentage expense in the category Car
and subcategory Fuel
for that month. Similar is the case for other categories and subcategories. How to do it ?
Here is a demo wiki - https://demo-complete.tiddlyhost.com/