
1. Re: Fixed LOD calculation
Joe Oppelt Aug 23, 2018 9:47 AM (in response to naga.kodali.1)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
Esther Aller Aug 23, 2018 10:05 AM (in response to naga.kodali.1)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
Deepak Rai Aug 23, 2018 10:26 AM (in response to naga.kodali.1)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
naga.kodali.1 Aug 24, 2018 12:47 PM (in response to naga.kodali.1)1 of 1 people found this helpfulHi 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

5. Re: Fixed LOD calculation
Deepak Rai Aug 24, 2018 12:48 PM (in response to naga.kodali.1)Yes That way the way. Please Close Thread to Help Others