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