10 Replies Latest reply on Aug 23, 2017 11:28 PM by Zhouyi Zhang

# Sum result of LOD calculation and then use as a dimension for summary

There are a total 7 different products (AS, ES, MS, NS, OP, P&A and WS).  If a customer booked a product with the booked amount  >= 10% of total bookings we apply a score of 1 else 0.  We want a stat of how many customers booked only 1 product or a combination of 2 products and so on.  Summary table should look like the one next to the large blue arrow.  Thanks.

• ###### 1. Re: Sum result of LOD calculation and then use as a dimension for summary

Hi, Myrna

Below is snapshot of result

Hope this could help

ZZ

• ###### 2. Re: Sum result of LOD calculation and then use as a dimension for summary

Thanks a ton ZZ!!!

I copied the expressions listed in measure and dimension.  However I cannot find WINDOW_SUM and do not know how to create a filter First()==0.  I tried to replicate Sheet 6 but it does not show the correct result you have.  Can you please walk me through how you did it?

• ###### 3. Re: Sum result of LOD calculation and then use as a dimension for summary

Hi Myrna,

You can create a calculated field or ad-hoc calculation to achieve the result.

Just double click the empty area in the marks card and start writing the formula.

Hope this helps.

~Tushar

• ###### 4. Re: Sum result of LOD calculation and then use as a dimension for summary

Hi, Myrna

ZZ

• ###### 5. Re: Sum result of LOD calculation and then use as a dimension for summary

Thanks ZZ and Tushar!!

I'm almost there - cannot take out SAV Name without impacting the summary table.

• ###### 6. Re: Sum result of LOD calculation and then use as a dimension for summary

Hi, Myrna

You need set up the table calculation for the filter as shown below

Hope this could help

ZZ

• ###### 7. Re: Sum result of LOD calculation and then use as a dimension for summary

I did the table calculation but SAV Name is still showing.  Attached is the Tableau packaged file with Sheet 7.

• ###### 8. Re: Sum result of LOD calculation and then use as a dimension for summary

Hi, Myrna

Now I see what you mean.

Please see the step below to hide the header of SAV Names

ZZ

1 of 1 people found this helpful
• ###### 9. Re: Sum result of LOD calculation and then use as a dimension for summary

Thank you,thank you!!!