Hello.
One problem; maybe somebody might help.
We want to have rows only from article-groups ("Deb-Artikelrabattgr."), which one customer bought in a sum of e.g. 5.000 EUR per year.
But with the following data I get all article-groups, although sum of them ist lower than 5.000 EUR. So I get to much data.
=nl("Zeilen";"Provisionsposten";"Deb.-/Artikelrabattgr.";"Datenquelle=";"DWH";;;"Rechnungsdatum";$K$9;"Debitorennr.";$G14;"Betrag (MW)";"<>5")
We work also with cubes in Jet-Professionals; here I get the sum of the sales volume:
Is it possible to combine formula one and two?
=nl("CubeValue";"Provisionsposten";"[Measures].[Betrag_MW]";"Datenquelle=";"Cube_1";"[Buchungsdatum].[Time].[Date]";$T$7;"[Debitor].[Debitornr]";"@@"&$G14;"[Artikelrabattgruppe].[Code]";$J14)
Thank you
regards
Klaus