No magic formula for that.
There is a SumField transform, but that outputs the sum but not the data. It’s not going to give you the data with a sum row at the bottom.
Ok tanks for your respond. Have you a solution for me with this issue… i need an export data with a bottom sum field. Other solution, custom developpment… ?
Tanks
Damien
Ok. I wrote a transform and added it to version 2.9.12 which I am releasing now.
See: SummationRow
Hi Michael,
Tanks a lot for this solution it’s work fine !
Always for the same project a last thing I need to know if it’s possible to give a determinate place for the different “submit login” people.
Tanks a lot
Damien
You can use “tfilter” just like “filter” but “tfilter” happens before the transform (SummationRow).
Ok, for made simple, if i write :
tfilter=”Submitted Login=test0″ it’s ok “test0” display ok, but if i write tfilter=”Submitted Login=test0,test1,test2″doens’t work. Witch code put to have test0,test1,test0 in order in my Submitted Login column ?
Tanks
Damien
Submitted Login=test0||Submitted Login=test1||Submitted Login=test2
filter show the three differents Submitted Login, but not in the order that i want by row. it show :
test2
test0
test1
I need to see :
test0
test1
test2
or the order that i want…
Tanks
Damien
I am confused. I thought you were asking to filter out certain values. Now I think you are asking to order the values.
If you want to order the rows by a certain column use torder="column-name"
Don’t use tfilter unless you wish to limit the results to just rows that match it.
Hi,
torder=”column-name”, nothing happens… with orderby=”Submitted Login” it reorganize the column, but not like i want.
My code is :
[cfdb-table form=”form1″ show=”Submitted Login,Repas-primaire,Repas-adulte,Repas-maternelle,Potages” torder=”” trans=”SummationRow(Repas-primaire,Repas-adulte,Repas-maternelle,Potages)”]
I need to reorder the rows by login like i want in Submitted Login column.
Tanks
Damien
torderby=”Submitted Login”
i already try it but it reorganize Submit Login by first Submit Date, but not like rows that i want… i’m deseperate.
Tanks
Damien
[cfdb-table form=”form1″ headers=”Submitted Login=écoles” show=”Submitted Login,Repas-primaire,Repas-adulte,Repas-maternelle,Potages” torderby=”Submitted Login” trans=”SummationRow(Repas-primaire,Repas-adulte,Repas-maternelle,Potages)”]
Nothing other
Tanks
Ok, I see that is not sorting as expected. Try this:
[cfdb-table form=”form1″ headers=”Submitted Login=écoles” show=”Submitted Login,Repas-primaire,Repas-adulte,Repas-maternelle,Potages” trans=”NaturalSortByField(age)&&SummationRow(Repas-primaire,Repas-adulte,Repas-maternelle,Potages)”]
instead of tordery, I added NaturalSortByField to the transform.
