4 Replies Latest reply on Aug 16, 2013 7:36 AM by alison.davis.0

    Filter by sum of a measure within distinct dimension

    alison.davis.0

      Hello,

       

      My data set is much larger and more complex than this, but this sample should suffice. I have a set of data in Excel that is basically arranged like this:

       

      Unit NumberPlant NameCapacity (MW)
      1AA5
      2AA6
      3AA7
      4AB4
      5AB1
      6AB9
      7AC14
      8AC33
      9AD6
      10AD27

       

      I would like to create a filter that allows me to filter at the PLANT level (not the unit level) by sum of capacity. For example, I would like to be able to filter out all distinct plants that have less than 30 MW of capacity. Ideally, I would like to be able to filter along the scale of plant capacity.

       

      Basically, I need to calculate the sum of capacity at each distinct plant, and then filter based on that sum. I do NOT want to filter based on the capacity at the unit level.

       

      I am also filtering on multiple other dimensions and would like this filter to be used on top of those filters.

       

      Any advice? Thanks in advance for your help.