How:Slice & Dice Library Data: Difference between revisions

Jump to navigation Jump to search
m
no edit summary
mNo edit summary
mNo edit summary
Line 74: Line 74:


=== Aggregation ===
=== Aggregation ===
There is nothing to aggregate in Customers. In the Products '''[[Library Edit screen]]''', under the Aggregation tab, add the following aggregations;
There is nothing to aggregate in '''Customers'''. In the '''Products''' '''[[Library Edit screen]]''', under the '''Aggregation''' tab, add the following aggregations;
* Sum '''Std price''' on the left
* Sum '''Std price''' on the left
* Sum '''Cost''' on the right on the same line
* Sum '''Cost''' on the right on the same line


In the Orders '''[[Library Edit screen]]''', under the Aggregation tab, add the following aggregations:
In the '''Orders''' '''[[Library Edit screen]]''', under the '''Aggregation''' tab, add the following aggregations:
* Sum '''Product cost''' on the left
* Sum '''Product cost''' on the left
* Sum '''Quantity''' on the right on the same line
* Sum '''Quantity''' on the right on the same line

Navigation menu