
1. Re: Calcuation (using LOD's )
Zhouyi Zhang Apr 19, 2018 6:05 AM (in response to DIVYA TIKKISETTI)Hi, Divya
Any sample workbook can be shared so that will be easier for people here to help?
ZZ

2. Re: Calcuation (using LOD's )
Jim Dehner Apr 19, 2018 6:41 AM (in response to DIVYA TIKKISETTI)Good morning
your workbook did not come across so I did the attached superstore example with your formulas (slightly modified)
this is the result for your formulas as written
I converted the first formula to a filter
and place it on the filter shelf to true and now the formula 2 values are filtered by formula 1
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

filter problem.twbx 1.2 MB


3. Re: Calcuation (using LOD's )
DIVYA TIKKISETTI Apr 19, 2018 7:27 AM (in response to Jim Dehner)Hi folks,
Thanks for the response. I have attached workbook now to the original post. Please refer and let me know.
Hey Jim,
For ex lets say we have total customers as 200. So now both of my calculations should query 200 rows. Calculation 1 may return 100 and calculation 2 may return 125. Common customers needs to be taken.
But As per your result, if Calculation 1 is querying and resulting 100 count customers and calculation 2 is querying output of calculation 1 ( that is only 100 customers are being considered for countd (product code) which might not be the expected solution.
May be I am going wrong. Please correct my understanding.

4. Re: Calcuation (using LOD's )
Zhouyi Zhang Apr 19, 2018 7:51 AM (in response to DIVYA TIKKISETTI) 
5. Re: Calcuation (using LOD's )
DIVYA TIKKISETTI Apr 19, 2018 8:52 AM (in response to Zhouyi Zhang)Hi Zhabg,
Both the calculations are perfectly giving expected results.
But the output I need the common customer count between both the calculations.
How can this be achieved ?
Many Thanks for your time.