Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share more information (or ideally a sample) to show what you have and what are you trying to accomplish?
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!!
Sum() without Aggr() as list box expression will work? I doubt, but have not tested this out
oh yes, correct
the Expression of the variable is as follows
Sum({<
Customer.Region = {"Asia"}
}>
Revenue
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() */