Sales Vs All Sales Vs Total Sales

[devender]

Hi,

I have a table as below.

Product       Sales
Pro1               10
Pro2               20
Pro3               30
Pro4               70.

Now my question is what  would be Sum(Sales),Sum(All Sales),Sum(Total Sales)

[Andrei_Cusnir · Accepted solution]

Hello,

I am not 100% sure that I have understood what you mean by Sum(All Sales) vs Sum(Total Sales). However, the 3 different type of Sales calculations that I can think of are the following ones:

1. I have the following dataset (Slightly more values from yours):

2. Now we have the following Sales calculations:

• Sum(Sales) gives you the value that you have under column Sales
• Aggr(Sum(Sales), Product) calculates the total sales per product, so you can see that it accumulates the total of Sales per product
• Sum(TOTAL Sales) will give you the sum of Sales for the entire dataset

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.