Customer Snapshot Drop-Down Report on HANA views

[Cognosy]

Hi, I am a new joinee in the Cognos Team,
I have a requirement to make a report which will show customer snapshot at drop-down for 4 product categories(A, B, C, D) across 4 periods YTD,MTD -LY,TY ( Please refer the attachment). This report will be consuming the HANA views which are designed to have individualized column for each customer.

My colleagues/Seniors are saying this can't be done, Can somebody please direct me if it is possible to achieve the summary of each customer on drop down, where data changes upon selection. Ty