Adding a Constant field in Analysis for Office

Hello Experts,

I have a requirement to create/integrate a constant field in the table, I tried using Excel functionality to achieve this, but it does not solve the business purpose, any inputs on how this can be achieved, any help on this will be appreciated .

Thanks

Gaurav