3 Replies Latest reply on Feb 8, 2018 3:06 PM by Vishal J

# LOD Calculation Question

Hi Community,

I have two data sets: Revenue and Assets data. Revenue is a "summable" measure that can be summed up across months. However assets is a point in time measure that cannot be added up across months.

For revenues, we have 2017 data , whereas assets we have the latest snapshot of assets Dec-2017.

I would like to calculate the following:

Assets for 2017: this number should be 5000+4500+3000 = 12500

Return on Assets (RoA) = Total Revenue / Total Assets = 1461/12500= 11.7%

I would like to be able to show this RoA by Product as well. Is this possible? I believe you can do this with an LOD calculation, however I don't know which one to use. I've also added both the source data and the tableau file.

Vishal

• ###### 1. Re: LOD Calculation Question

See attached.  I can't connect what I'm seeing in here with the description of your problem statement.

What should be the asset number you want to use here?

And are you evaluating things by [Product]?

• ###### 2. Re: LOD Calculation Question

Attached 10.5 version workbook.

I think you should use fixed LOD at Product level.

Assuming the Assets doesn't change for time but only for product.

SUM({Fixed Product: MAX(AUM)})

If Assets change for time as well then add Time level along with Product in Fixed LOD.

SUM({Fixed Product,Tiime: MAX(AUM)})

EDIT: For both Product and Time, the second calculation might give inconsistent results. Please be cautious of it.

• ###### 3. Re: LOD Calculation Question

This seems to have done the trick. Thanks Maneesh.