excel report to Cognos

[CognosAdmn]

hello Everyone, 
I am trying to re-create an existing excel report in cognos. This current excel reports contains 30 rows and four columns.

column one has has the metric name;
column two has the metric for a certain day selected by user via a date-prompt;
column three has the average or maximum or minimum or percentage for the past 30 days;
column four has the average or maximum or minimum or percentage for the past 60 days.

each of the 30 rows has a different calculation.

Could you please advise what the best way is to accomplish this?

Any help will Greatly Appreciated.

Thank you.