It's quite difficult for us to understand your request without any data.
Could you share your packaged workbook(***.twbx) or sample excel file or something to start with?
so you want to show % completion for current moth target as overall as well as at the office level.
it means you need 2 charts or tables.
as Shin mentioned, if you can provide meta data, it will be really helpful.