Matrix visualization total value, Quarter split

[rajendraongole1]

Dear All,

I have prepared a matrix visualization with hirarchy where total values are reporting perfectly fine,. but here i got to report for some of the values with quarterly result/output split as shown below image: 

Example: Current year projected input value is 300, need to split Quarterly as shown.

please support to acheive this.

[Anonymous]

Hi @rajendraongole1 

You need to add hierarchy to columns of matrix too, like Year - Quarter.

In addition, are the "Current Year Projected Input", "Previous Year Actual Loaded" measures or columns? Does the quarterly data already exist in the data table? Or do we need to compute the quarterly data according to some specific logic?

Best Regards,
Jing