5 Replies Latest reply on Aug 24, 2018 12:48 PM by Deepak Rai

# Fixed LOD calculation

Hi All,

I am looking for guidance on the  Fixed LOD calculation.

I am trying to calculate the top customers in the company by quantity for the last 6 months lets say Jan -June 2018

There are many other dimensions in my view .But I need to find top customers by quantity for the  product category lets say  Furniture.

I already have filters placed on product category: Furniture and Months selected from Jan-June.

Should my fixed calculation read as

{Fixed [Customer],[Month],Product Category]: Sum(Quantity)}

(OR )

{Fixed [Customer]: Sum(Quantity)}

Kindly advise !

Thanks,

Swapna

• ###### 1. Re: Fixed LOD calculation

You want all the dimensions in that calc, I think.

You want the sums at that level of detail (which is what LOD means, after all!)

• ###### 2. Re: Fixed LOD calculation

Hi Naga,

I agree with Joe, typically you do want to include all of the dimensions in your LOD calc. Remember it will return a value of SUM([Quantity]) for every unique combination of all specified dimension values.

In other words, the first calculation will return the sum of quantity for every combination of [Customer],[Month], and [Product Category].

Whereas the second calculation will return the sum of quantity for every combination of [Customer] regardless of the values of [Month] or [Product Category].

Also remember, if you do not have a dimension specified in the FIXED then the calculation will not be filtered by that dimension. Calculations with Fixed Expression Return Unexpected Results When Filtered | Tableau Software

• ###### 3. Re: Fixed LOD calculation

Hi Naga,

Since you need 6 months of data, Just add a Calc to Filter to get Data from Jan to July, Then Use This Calc

{Fixed Product Category,Customer : Sum(Quantity)}

and then find Top N.

Thanks

Deepak

• ###### 4. Re: Fixed LOD calculation

Hi All,

Thanks for providing all tour inputs. That's really helpful.

As I need to calculate top shipper by quantity irrespective of other dimensions in the view.

I have added date(6 months) and product category:furniture filters to context and then considered the following fixed calculation:

{Fixed [Customer]: Sum(Quantity)}

Thanks,

Swapna

1 of 1 people found this helpful
• ###### 5. Re: Fixed LOD calculation

Yes That way the way. Please Close Thread to Help Others