Help with Pivot Table

Hi, guys I'm currently building a dashboard and having some challenges with it.

Ive broken down the weekly results, but we have a monthly target that then has a quarterly target.

one of the data feeds currently looks like this

example 1.png

However a couple of things

the target is totaling the weekly breakdown and i don't want that as it's a monthly target (One figure) , and I want to show it weekly progress against the monthly target. ( The monthly target is showing weekly so it can be measured)

the second thing is I want to show the target as a line to show against the reported target and the validated (Audited) number

so my bar graph currently looks like this

Graph.png

I've tried to put a cluster and line in but its not working.

any help is appreciated!

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Perhaps the following is closer to what you want.
I put Month in the Rows area
I put Quarterly Sales Volume Reported (Sum), Quarterly Sales Volume Validated (Sum) and Target Figure (Max) in the Values area.
I produced a pivot chart which initially was clustered columns but then changed the Target Figure columns to a line graph which is linked to the secondary axis.
Let us know if you have any questions.