What are Aggregation rules?
Aggregation rules tell the application how to group the data together when it is being summed. For example you can group data by day to give a daily view. You can group the data by day and store to give a store sum on each day. You can group the data by day and by transaction to give a sum of each transaction in each store on each day.
Aggregation rules tell the application how to group the data together when it is being summed. For example you can group data by day to give a daily view. You can group the data by day and store to give a store sum on each day. You can group the data by day and by transaction to give a sum of each transaction in each store on each day.
Group by examples:
- Day = Lets you see the sum of sales by day.
- Day * Country = Would let you see the sum of sales by country by day.
- Day * Country * Store = Would let you see the sum of sales by country by store by day.
- Day * Country * Store * Transaction ID = Sum of sales by transaction id by store by country by day.
- Day * Country * Store * Transaction ID * Department = As above but splits each transaction into departments and sums sales at this level.