2 Replies Latest reply on Sep 8, 2016 2:33 AM by Mahfooj Khan

# Can someone help in this..

what is the difference between

total(sum(sales))/total(contd(product sub category)) and sum(sales)/countd(product sub category)@

• ###### 1. Re: Can someone help in this..

Hi Vishnu

1.total(sum(sales))/total(contd(product sub category)):

Here, sales are summed up for the whole partition first(partition is a pane or a whole table- see in "Compute Using" option for Calculation1)

Similarly, distinct count of Product sub category is taken for the whole partition(not individually)

This is because of TOTAL() function.

Then, total sales of a partition is divided by the number of product sub category in that partition.

Attached screenshot with "Calculation1" will make you clear!(I have taken here "pane down" calculation)

2.sum(sales)/countd(product sub category): sum of sales for particulat sub cat is calculated(individually) and the distinct count a particular sub cat is taken i.e. automatically 1. therefore, sum(sales)/1=sum(sales) Example in screenshot: 114,880/1=114,880

Note: "Total" at the end of each pane is Grand Totaol, not TOTAL() that is used in calculation.

Also, if in Calculation1 i.e. TOTAL(), if you choose "Cell" as "Compute Using" option, then both the formulas you wrote will be the same!!

This is this much simple Vishnu! I hope this will help you for sure.

Rahul

1 of 1 people found this helpful
• ###### 2. Re: Can someone help in this..

Let assume you've data like this

2nd case

Hope you understand

Mahfooj