this will total the last 4 week
I did a dual axis plot and sync the axes and it returns this
set the table calc like this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
SampleWorkbook.twbx 12.1 MB
Thanks a lot for the answer. That solved it. Really appreciate the help.
Glad to help out