Hi. How can we help?

Sale Line Measure: Subtotal

Analytics has now added the Sale Line Subtotal to the available measures on Sales Reports.

The Subtotal measure will help make it easier to balance totals between Retail and Analytics, but there are also some important points to keep in mind when building reports with the Subtotal Measure.

What is the Sale Line Subtotal?

The Sale Line Subtotal is the dollar value of the items on a Sale before they had discounts applied, and before any taxes were applied.

If a Sale Line was a return, its Subtotal is expected to be negative.

Why include the Subtotal in Analytics?

In Retail R-Series, the Subtotal is the first number prepared in the summary of reports.

Upon the Subtotal, all discounts are applied to identify the real store income before any taxes are added.

Why use a different Total in Analytics than Subtotal?

The Analytics Sale Line Total is an important number because it is the value that is actual income.

It is the Total that we use to subtract Costs and determine Profit

It is the Total that we use to determine Margin

It is also the Total upon which Taxes are accordingly applied

It's important to keep in mind that your subtotal is not your income. It cannot be used to measure profit., to calculate margins.

The Sale Line Subtotal and the Looker Subtotals tool aren't the same. 

  • The Sale Line Subtotal is the value of Sales before discounts were removed and before taxes were applied.
  • The Looker Subtotals tool is completely different. It is used to find sums or averages of sub-groups of data when two or more Dimensions are present.

For example:

So, the tool and the measure are serving different functions.

Was this article helpful?

0 out of 0 found this helpful