Hierarchical Table/Matrix with Subtotal and Grand Total

[mohit_chourasia]

Hello Learners and Experts,

I am new to Looker and exploring looker’s different feature. I wanted to create Hierarchical table from below mention data.

I am trying to use Column A,B and C into single Column with Hierarchy, Date as column and show sum of the Numbers in the matrix. 

Sample Data 
 

And want to achieve below visualization with yearly Subtotal and again the Grand Total.

Expected visualization

Is this possible to achieve this viz. in looker.

Thanks & Regards,

Mohit