Data operations

[#1]

Hello,

this is my issue i have this kind of data set :

I would like for each op calculate lthis expression q*price/sale and have this amount as a row of a table.

thanks for your help guys.

regards

[vishsaggi]

Try this attached and let me know?

[#3]

this is exactly what i wanted to do. my problem is that the script you used is making an error i can't use it my  data

Final:

LOAD Operation,

     Sum(montant_affaire) AS Mnt_Affre

Resident

Data

Group by Operation;

[vishsaggi]

Can you send me your actual script ? And the expected Graph you are looking for ? Can you send me the output you want as a screenshot if possible?

[#5]

As you can see in the attached file i adapted your script for my need but it makes an  error does'nt recognise de operation field and i can't get the mnt-affre field

[vishsaggi]

Ahhh I thought so. You have some special alphabet characters in your field names. Use the below script in your QVW file and let me know? Change those field names from special character e to normal e in your excel sheet and use below script.

The letter e has a small apostrophe on the top.

Data:

LOAD Operation,

     Qte,

     Mnt_Net_client,

     TF,

     gdf,

     (Qte*Mnt_Net_client) AS montant_affaire

FROM

(biff, embedded labels, table is Feuil1$);

Final:

LOAD Operation,

     Sum(montant_affaire) AS Mnt_Affre

Resident

Data

Group by Operation;

[#7]

hello,

the error was my use of resident data.

I really thanks you for your support.

regards.

[vishsaggi]

Can you send me the actual script you are using and the error screen shot you are getting ?

[#9]

Hello,

It is now working. I have no more error.

Thanks for your support.

Ragards