Creating Ranking Leaderboard of Transaction

[Yongki]

Hi @Matzumoto ,

This is possible using parent-child (1-to-many) relationship.

An example is like this,

Campaign is higher level
Customer is middle level
Transaction is lower level, this is where price located

If you need more detail, you can have
lowest level for Detail of Transaction, which can have its own price
highest level for Department, which can accumulate total from Campaign

I have unfinished tutorial regarding this,

Collections cascading and copy

Hi All, This is a series of tutorial about relational collections that are cascaded, meaning it is maintained in 1-to-many relationship. There are 5 levels of collection, from top to bottom: highest such as projects higher such as activities inside project middle such as purchase orders inside activity lower such as order items inside purchase order lowest such as accessories inside order item But, we will begin with lower first and later, we will use lowest, then going to middle, higher …

each level need to be connected to the level above it, using 1-to-many.

I suggest you simulate this in spreadsheet first, and think about leveling.