GENERATE MATRIX WITH NEW LINE CREATED BY MEASURE

[nasolme]

Hi Community,
Thanks to my database, I get this result.

But I have to complete this matrix with new elements which are not present in the database, but which are obtained by a simple calculation. How can I get this result ?

I tried to create a table and one to many relationship, and use switch(TRUE()... Without success. 

[Anonymous · Accepted solution]

HI

You have to create 2 measure

Marge=[CA TTC]-[PRIX_REVIENT_TTC]

Marge%=divide(Marge,[CA TTC]

But first you do not seem to have already have lmeasure for CA TTC and Prix reveint TTC

CA TTC=sum([CA_TTC])

PR TTC=sum([PRIX REVEINT TTC]