Please help on data model . Not sure what to do get needed result

[prahlad_infy]

Hello Sirs ,

Please tell me what , whethere i am going with wrong data model to achieve below output . I am not surly on how to getting output in below format without merging two table into single table in data model .

Q1,Q2,Q3,Q4 - values are based on the counting of LOG_ID which have REMARKS = G .

Monthly TARGET * 3 decides , if the count of Q1,Q2,Q3,Q4 are meeting qtrly target .

But I am gotting

Please Help

Thanks you .

[Anil_Babu_Samineni]

If you can simplify with small volume of data, It would help to understand your partial data model instead full? How you say?

[prahlad_infy]

stalwar1‌ ... Please let me know , if iIam making myself clear or this cannot be achieved

[prahlad_infy]

Sir .. thank you for replying .

I tried explaining with screenshot to Sunny . Can you please let me know what I am failing explain with example from your side ...

Sir .. i have shared an attached xl sheet with tables and sample output ..

One table maintains target another table is of transactional nature ...

[Anil_Babu_Samineni]

Excel is fine, What output you are expecting?

[prahlad_infy]

BELOW IS SAMPLE SMALL DATA AND EXP OUTPUT. I HIGHLIGHTED FOR EASY REFERENCE .

Table2

Table 1

OUTPUTE

[Anil_Babu_Samineni]

Now explain how Quarterly Target calculated?

[prahlad_infy]

Let say for a record Monthly Target is 2
then for that record quarterly target will be 2 * 3  = 6
6 is quarterly target for that record

[prahlad_infy]

Any solution sir ?