embedding 2 modules data in one chart

[ali_hijazi]

Hello

I got the following data (check attached)

I want to create a bar chart and add as dimension the field Group

but I want to see for the values of G1 and G2 the total of Amount

is this feasible or I have to have the data in a different format?

Please advise

[Gysbert_Wassenaar]

See attached qvw

[ali_hijazi]

no this is not what I want it should be G1 corresponding to 1500 and G2 corresponding to 3000; following the country and branch

[Gysbert_Wassenaar]

Why? What is the logic behind that?

[ali_hijazi]

we are getting data into one QVW document for two modules but we are trying to make comparisons

the modules are related to Disciplinary actions, and performance management, and sales

for example from those whose result was exceptional or satisfactory how was their contribution to sales in the next 6 months or after the performance evaluation interview was made, or out of those who were marked as exceptional , satisfactory what is the percent of employees out of each bracket who had disciplinary infraction

[Gysbert_Wassenaar]

Why does G2 correspond to 3000 and not to 1500 or 1000 or 3.14? What is the logic? What does the source data look like?

[ali_hijazi]

G1 is related to Branch B1 in PMS and in Sales B1 has 1500 as amount and so on

[Gysbert_Wassenaar]

I think you used a concatenate in the script where you should have used a join.