Hi,

You can try this,

<record id="hr_holidays_view_pivot" model="ir.ui.view" >
        <field name="name">hr.holidays.view.pivot</field>
        <field name="model">hr.holidays</field>
        <field name="arch" type="xml">
            <pivot string="Time off Analysis">
                <field name="you can add the required field" type="measure"/>
            </pivot>
        </field>
    </record>

Also, you can add the pivot in the view_mode of the action record

Regards