3 Replies Latest reply on Mar 8, 2018 4:56 AM by Vimal Annamalai

    How to get the sum of maximum values from a particular field based on Multi value filter selections?

    Vimal Annamalai

      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.