3 Replies Latest reply on Mar 29, 2018 10:50 AM by Deepak Rai

# Divide using the sum of an average

Hi,

I'm far from a Tableau expert and I am hoping someone can point me in the right direction to create a viz as described below. This is fairly urgent and I keep thinking it should be fast and straight forward but I'm just not sure about the best approach.

I have a table of data with a list of transactions.  The first 4 columns are parameters or dimensions for each transaction.  Column 5 is a date stamp - it is just the first day of the month in which the transaction happened.  The last 3 columns are numerical results of the transactions.  Here is a screen shot form the attached workbook. I would like to use a filter to choose a range of dates.  Then within that range of dates I'd like to sum all the values in column O and subtract the sum of column R.  Then I would like to sum column B for each date/month within the range and average those values.  Then the final calculation would be to divide [sum(column O - column R)] by  [average(monthly sums of column B)].   I'd like to be able to display the results segmented in a table with rows for Level and columns for Tier.  Here is an example layout using just the average of column B. Cheers,

Greg

• ###### 2. Re: Divide using the sum of an average

Hi Deepak,

I think that's it! The level of detail calculation seems to be the trick - I guess I should study that function. Thanks for the fast reply.

Sincere best regards,

Greg

1 of 1 people found this helpful
• ###### 3. Re: Divide using the sum of an average

Great!!! Can you Please Take a Sec To Close Thread by Marking my Reply as Helpful and CORRECT.

Thanks

Deepak