Hello Team,
I have a calculation which calculates current + 4 previous quarter but it removes previous quarter and Year from the filter.
I want the calculation will work dynamically if new quarter adds then it should calculate current qtr along with previous qtr and all the filters should be there, so that we can see other year's data too.
I have attached sample workbook for your reference.
Regards
2 réponses
Hi Ashish,
Please use below calculation. And add this calculation to filter and apply top 5 by Calculation1 (max)
Please see below screenshots.
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer'.
This will help other users find the same answer/resolution.
Regards,
Peeyush
