help with aggregation and dynamic dimensions

[#1]

Hi,

in my table there are documents with different doctypes. In my diagram i want to show only the the documents in wich the documenttype is a certain one. i don`t know if i should use a dynamic dimension or a formula!? i tried to type this in my formula but it doesn`t work...

=SUM({1<VerkaufsdokumentKopf.Dokumenttyp={'2'}>} VerkaufsdokumentKopf.Grundlage)

VerkaufsdokumentKopf.Dokumenttyp is a small int field what is wrong in my expression? or what is a solution for my problem?

[#2]

I've never heard about such notation, but try this:

=SUM({1<Dokumenttyp={"2"}>} Grundlage)

[#3]

thx for your replys... no i found out that my problem is a different one my concatenate doesn`t work right. i have 2 tables one with fields x y z and the other with u and v now i load them in this way

newtable:

load x as a, y as b, z as c from table1;

concatenate

load u as a ,v as lol from table2;

my problem s that in newtable there are only the values ou of table1 the values of table2 are missing

[#4 · Accepted solution]

It works fine on my side. Take a look at attachment.

[#5]

i had qualified the fields...=) i know i`m a idiot

[#6]

Nobody is protected from this. And it happens with the best of us