What do I have to do to get the graph to look like this?

[Paknanarn23]

I have 2 data tables, using this code to find values. and find the percentage

Now I want to plot the values. by making a percentage and the total values ​​are plotted like this, what should I do?

[sidhiq91]

@Paknanarn23  Could you please post some sample data and also elaborate a bit more on your expected output.

[Paknanarn23]

I have graphed it now. But the graph doesn't turn out the way I want. Details are already in the post

In my graph there are KCe_Date and layer_no, the code fragment is as follows.This is the code used to make the bar graph

sum({<OP_WorkCenter = {'MAOI'}>}CQ_PNL_OUTPUT_MAOI) / sum(total <KCE_Date> {$<OP_WorkCenter={'MAOI'}>} CQ_PNL_OUTPUT_MAOI)*100

This is the line graph code.

sum(total <KCE_Date> {<OP_WorkCenter = {'MAOI'}, LAYER_No={'04','06','08','10','12','14','87'}>}CQ_PNL_OUTPUT_MAOI)