In my app, it has a portal that is displaying a related table(This is about bill detailed statement which item bought).
The related table has fields such as "date", "item_no", "amount", "unit price".
There is a record called "the number of bills(assuming item_no=999) that tells me how many customer came on that day"
The rest of the records are something like "apple(item_no=001)", "orange(item_no=002" and so on.
I'd like to show the ratio of these each item against the number of the bills on each day that is being displayed on each row in the portal.
Can I make it calculate and show the result somehow?
Or do I always have to have the calculation field in the related table which is calculated by self relation(related with date, and item_no to count the number of the bill")