Suppose I add a user-property field called 'amount_recovered'.
[type = BIGINT
index = Regular (I think) ]
How to calculate total for amount_recovered field for:
- Display value of 'amount_recovered' from user profile details in link.html & detailed.html page?
- Display total for 'amount_recovered' for all links any single category.
- Display total for 'amount_recovered' for all links for any desired category & all sub-categories under it.
- Display total for 'amount_recovered' for Entire website.
Example:
For a legal directory, I will be asking law-firms to input $ amount for the cases they have won/setteled so far.
Usage:
- So for the category of Dallas, I want to have the ability to display 'Grand Total' of 'amount_recovered' all the listings in Dallas Category.
- While for Texas (parent category of Dallas & all other cities in Texas), ideally I want to be able to display grand total of all.
.. note: there might be few users who will have multiple listings, as some law-firms have offices in different cities. So in this scenario, we want to avoid doing multiple total additions.
- Ability to display grand total for all links in the entire directory.
- Ability to display grand total for all links . (or I suppose I should saw, grand total for all users)
Thank you.
Vishal
-------------------------------------------------------