Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I view my accounts data as a T-account:
Can you expand a bit more, what does the data look like? Are all fields in the same column? If so why not use a pivot table?
ok...this is the example
the field "conto" (sign D) 1102999989 is repeated more than once in the face of n counterparts (sign A) ...
I would repeat it only 1 time ....
Ah, the field "conto" is a file to the field "S" (= D),
from the field "contabilitagenerale.importo" is another file ...
the 2 files are attacked by the "data / N ° reg."
with a pivot fields from the "contabilitagenerale.importo" on you do not appear to me ..
I do not know is there any keyword that allows me to see the field "account" only once??
I hope that I explained a little better ...
I think I understand what you mean, why don't you use the distinct command in your table?
So make a straight table and use the expression:
Sum (Distinct conto),
You can even do a distinct load if you don't want to detail at all.
Does that help?
Ben
sorry but I did not understand ...
the chart that I sent you before is a table on the table ... I can sum (DISTINCT)?
the script can not do it, because the file where there is the "account" has other fields that I need ..
I am attaching txt where I'll show you the result and outcome of the pivot table ..