How to get total of rows per year

[Anonymous]

My data looks like this

And this is how my data is supposed to look like

[Anonymous · Accepted solution]

Hi my current data looks like this after following your suggestio

How can I make it look like my target data?

[tex628]

Hi, 

You're using the table visual. Swap to the Matrix and you should get the desired output:

Br,
J

[Anonymous · Accepted solution]

Hi my current data looks like this after following your suggestio

How can I make it look like my target data?

[tex628 · Accepted solution]

You need to move the Quarter dimension from column to row:

Then expand the row dimension down to quarter level:

Br, 
J