Hi All,

Please forgive me if my doubt is meaningless!!!

My Requirement is,

                         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.

Current Case:-

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.

Release Filter:-

Current Chart:-

Just calculating the Maximum(outstanding bugs) for available Release names for a particular date alone, Even-though, All values selected in Release Filter

Let me know, If i didn't explain my requirement correctly or any changes to be occur in my existing data-source structure.