It works for most of the selection values but not for few in some scenarios.
Lets say we selected 2 Sub-Category and don't have some combination of data for certain months.
Lets say we have Jan-17 to Jan-18 data for Sub-Category 1, and for Sub-Category 2, we have data from Jan-17 to Jun-17 & Oct-17 to Jan-18.
In this case,Sub-Category displayed for 3 months will treat as single value and hence we see the sheet.
Please let me know if there is any other work around.
1 of 1 people found this helpful
I found the solution.
Window_Min(Min(Sub-Category))=Window_Max(Max(Sub-Category))and set to True.