Any sample workbook can be shared so that will be easier for people here to help?
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
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
Thanks for the response. I have attached workbook now to the original post. Please refer and let me know.
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.
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.