22 Sept 2021

Posted on:

16 May 2021

0

# Why are using SUM here...it is not very clear to me

This is in reference to calculating the GM%

Instructor
Posted on:

17 May 2021

2

Hi Gourab,

If we don't use the SUM function we are not calculating a total for 'Gross Profit' and 'Revenue' for the respective month.
Both variables consist of multiple entries and we need to sum them to obtain the total for let's say January. This works similarly to pivot tables.

Best,
Ned

Posted on:

18 Aug 2021

1

Then why do we not need to use SUM from the previous lessons when calculating cogs?

Posted on:

22 Sept 2021

1

Okay, I think I get it.

When calculating COGS, we made the calculation for each individual sale.
Then Tableau showed us the sum in the visualization, just like it did for other columns.

When calculating Gross Margin, if we don't use SUM, then Tableau will calculate for each individual entry and then show the sum of that. So it actually adds up all the percentages of the individual sales which is why we get huge numbers.

So, when we specifically mention SUM, then Tablue takes the sum of all the months, which is what we want for the correct calculation.

Did I make sense?