Reseting Running Total Bar Graph

user05047

I want to create a cumulative bar graph of my sales where the total value resets each quarter. What is the best way to do this?

 

e.g.

Data:

Q1 Week 1: 10

Q1 Week 2: 7

Q1 Week 3: 13

Q2 Week 1: 6

Q2 Week 2: 9

Q2 Week 3: 11

 

Graph:

Q1 Week 1: 10

Q1 Week 2: 17

Q1 Week 3: 30

Q2 Week 1: 6

Q2 Week 2: 15

Q2 Week 3: 26

Tomo

I think the easiest way for which an arithmetic expression isn't used in particular is below.

特に計算式などを利用しない一番簡単な方法は以下だと思います。

 

But, correction of a character string is needed in order to sort in QuarterWeek.

ただし、QuarterWeek でソートできるように文字列の修正が必要です。