I want to calculate the sum(max(outstanding bugs)) based on the releases are selected in Multi selection Filter(Release Filter). If I select All values, It has to show Sum(Max(outstanding bugs)) for All releases for each & every date even-though if selected releases are not available for that particular date. I have attached the workbook and data source excel also.
My current chart displaying the maximum outstanding bugs column value of particular date & It is not showing the values based on multi selection filter(Name - Release Filter in my case).
Below example will explain it clearly:
If you see for 2/2/2018, It holds only few releases (Release Column). So for that few releases, It just retrieving the maximum outstanding value alone.