Retain Filter value when the selection criteria return no value and display as 0
Here is my scenario
1. I have Fiscal Year, Period, and cost center as filter criteria.
2. When I Select Fiscal Year, Period, and if the cost center combination has no values for the Year and Month Selection.
It clears out the Filter - Fiscal Year
For the Cost center combination result set it shows values for the cost center from a different period and year.
I want to display as 0 if the selected filter combination does not exist. Is there a way to achieve it?
If anyone has worked on such an issue please let me know what have you done to resolve it.
Thank you.