How can I sum for each week like below?
@wonka1234 Can you please provide sample raw data, not crosstab :-) ?
@albert_alaluf hows this?
perfect, working on it.
I made some search, and I found another solution. I just implemented to yours. I don't deserver full credit :-)
Please marked as a solution if this helps.
@albert_alaluf not quite the output looking for.. looking for it to be like this
@wonka1234 One way of doing this
Could you please explain the formula on what it does please.