Good morning

I am editing a Pipeline Revenue Report table in my document

the default formula is "

PIVOT("1","expected_revenue","date_deadline:month","01/"&FILTER.VALUE("Year"),"team_id","1","won_status","won").

this formula shows me the planned closing date but I want a formula with the closing date so I rewrote the code with

"PIVOT("1","expected_revenue","date_closed:month","01/"&FILTER.VALUE("Year"),"team_id","1","won_status","won")"

I replaced the date_deadline with date_closed;

but the code doesn't work please help me

i have odoo standard online