5 Replies Latest reply on May 4, 2018 4:48 AM by David Maning

    Creating calculated field with subgroups of one dimension

    Daniel DeVita

      Hi,

       

      I have following workbook structure:

      Where the arrows are, I want to add a field that provides the difference between 'BASE' and 'COMPARISON' figures.  My issue is that the BASE and COMPARISON figures are based on the one dimension; AVG(Travel Time), which is split up by 'Base or Select' depending upon a TRUE / FALSE boolean.

       

      Does anyone know how to do this without having to duplicate the 'Travel Time (mins)' measure?  I know I how to achieve the right outcome if I duplicate the measure, but I wanted to know if there was a better way (or different way) to do this.

       

      Regards,

      Daniel

       

      I apologise for the lack of a workbook, the underlying data is sensitive.  If the screenshot is not enough to work with, I can generate a sample dataset if required.