9 Replies Latest reply: Oct 14, 2011 4:29 AM by Torbjörn Ungvall RSS

    Gauge Chart with different expressions based on dimension

      Hi,

       

      I've a Gauge Chart that shows, for example operating costs in %:

       

      -(-(sum( {$<RR1_ReportRow={'Summa Driftskostnader'}>} RR_Belopp ) /
      sum( {$<RR1_ReportRow={'Summa premieintäkt'}>} RR_Belopp ))


       

      But if customer choose a dimension I have to use another expression:

       

      -(sum( {$<RR_Affär={'Försäkring'}, RR2_ReportRow={'Summa Driftskostnader'}>} RR_Belopp ) /
      sum( {$<RR_Affär={'Försäkring'}, RR2_ReportRow={'Summa premieintäkt'}>} RR_Belopp ))
      -
      (sum( {$<RR_Affär={'Försäkring'}, RR2_ReportRow={'Ersättning Agria'}>} RR_Belopp ) /
      sum( {$<RR_Affär={'Försäkring'}, RR2_ReportRow={'Summa premieintäkt'}>} RR_Belopp ))

       

      In a straight table I can use Dimensionality()=0, but that won't work here. Is there another way to do this without partial sums?

       

       

      @Ungvall

      Senior Business Discovery Manager at Advectas AB