Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Probably the best way to achieve this is to create another grouping field, associated with GROUPEMENT, which associates totalfrance with the two GROUPEMENT values that you require. The other GROUPEMENT values in the new group would simply associate with the same value.
Something like
LOAD *
Inline
[
GROUPEMENT, NEW_GRPOUPEMENT
rostra, rostra
zentiva, zentiva
totalfrance, totalfrance
Amleia, totalfrance
surpharm, totalfrance
...add more...
];
Now use the new field in the listbox place of GROUPEMENT.
Hi,
I want the output like
LOAD *
Inline
[
GROUPEMENT, NEW_GRPOUPEMENT
rostra, rostra
zentiva, zentiva
totalfrance, totalfrance // Should contain both sum of AMLEIA and SURPHARM data
Amleia, // AMELIA OLY
surpharm, t// SURPHARM oly
...add more...
];