Listbox and Aggr Function

[bmensing]

Good Day to everyone,

listbox shows the Dimension Customer, my pivottable shows the Revenue. The Revenue is stored in a variable, and all i want to do

is to show only customer with an Input in Revenue. And alternative, how does the Expression look like when the Revenue is not a variable, but a data field.

Best regards 

[sunny_talwar]

Would you be able to share more information (or ideally a sample) to show what you have and what are you trying to accomplish?

[vinieme12]

for your listbox use an expression as below

AGGR(

          if(sum($(Revenue))>0,Customer)

     , Customer)

For the second part , can you provide the variable expression for Revenue? the variable must be evaluating on a dimension!!

[sunny_talwar]

Sum() without Aggr() as list box expression will work? I doubt, but have not tested this out

[vinieme12]

oh yes, correct

[bmensing]

the Expression of the variable is as follows

Sum({<

        Customer.Region = {"Asia"}

}>

Revenue

[bmensing]

i think it makes sense to post the whole Expression of the variable..

sum(

aggr(

if ( BB_SperrZuord.archiviert = '0',

     Sum (

      {<

  V_BelegKopf.BelegArt = {"U", "G"},

  V_BelegKopf.AuftragsArt -=  {"50"},

  V_BelegKopf.LagerOrt -= {"1902", "1800"},

  V_BelegKopf.Firma = {"100", "160", "170", "180"},

  BB_SperrZuord.Sperrgrund -= {"996", "997", "998", "999"}

   >}

        ((V_BelegPos.Gesamtpreis + (V_BelegPos.Gesamtpreis * V_BelegKopf.proz_Zuschlag / 100) * V_BelegKopf.xc_Kurs))),

     Sum (

      {<

  V_BelegKopf.BelegArt = {"U", "G"},

  V_BelegKopf.AuftragsArt -=  {"50"},

  V_BelegKopf.LagerOrt -= {"1902", "1800"},

  V_BelegKopf.Firma = {"100", "160", "170", "180"}

   >}

        ((V_BelegPos.Gesamtpreis + (V_BelegPos.Gesamtpreis * V_BelegKopf.proz_Zuschlag / 100) * V_BelegKopf.xc_Kurs)))

       )  /* Ende if() */

        ,Kalender.Datum, V_BelegKopf.ReferenzNr, V_BelegPos.PositionsNr, V_BelegKopf.Firma

    )  /* Ende aggr() */

   ) /* Ende first sum() */