Skip to main content
DD-RET-001 Daily Grocery Sales and Store Performance Download this dataset Free account · takes a minute · you come straight back
DD-RET-001-Q001 Easy

Total net sales for the period

What is the total net sales value (after discounts) for the full reporting period?
Expected
One numeric value in SAR · KPI card
Tables
FactDailySales · columns
  • FactDailySales
  • NetSalesSAR
  • DateKey

Discussion

2 replies
  1. ayesha
    I opened this file for the first time. There is a sales column and a discount column both. For total net sales do we take sales as it is, or minus the discount first? Not sure which one is correct. How did you do it?
  2. admin_findi360
    Good question to ask first. You don’t need to subtract anything: the fact table already carries NetSalesSAR, which is sales after discount. Sum that column over the whole period. If you want to prove it to yourself, take one row and check gross minus discount equals net. Post your total and I’ll confirm it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us