6 Replies Latest reply on Sep 15, 2017 2:26 PM by Deepak Rai

# Sum of Count of LOD Combinations

On Tableau Desktop 10.3, I have a LOD expression field called "UniqOutcomes" to count unique outcomes as {FIXED [ID], [Outcome]: MIN(ID)}. I then add this field to the worksheet and COUNT the ID,Outcome combinations.

I am now trying to add these total number of combinations to the title of the sheet. The formula for the title reads: Outcomes (N= CNT(UniqOutcomes)). But the actual title then translates to Outcomes (N= 1 to 20).

instead of Outcomes (N= 31). So basically, instead of giving me the total of the number of unique outcomes i.e. 31, it is giving me a range of 1 to 20, which is the minimum and maximum value of the number of outcomes when sliced with the Outcome Dimension.

How do I make the title show 31 i.e. sum of the count of the combinations?

• ###### 1. Re: Sum of Count of LOD Combinations

Drag your Calculation to Detail and use it in the Title then using Insert.

• ###### 2. Re: Sum of Count of LOD Combinations

I mean drag Uniqcounts field to Details mark. Go to Title>Inset and u will find it there. Use it in your formula in Title.

• ###### 3. Re: Sum of Count of LOD Combinations

That's what I had done earlier. I inserted the same CNT(UniqOutcomes) to the title and it shows N=1 to 20 instead of N=31.

• ###### 4. Re: Sum of Count of LOD Combinations

Ok ...you need to aggregate it again

Create another Field

{FIXED:SUM(Uniqcounts)}

• ###### 5. Re: Sum of Count of LOD Combinations

{FIXED:COUNT(Uniqcounts)}

• ###### 6. Re: Sum of Count of LOD Combinations

{COUNT(Uniqcounts)}