Dear all,
how can I implement the XIRR formula direcly in a pivot table?
What I need is to represent in a pivot chart the IRR calculted at every reference date for the selected investments (throuhg a slicer). All of this, considering that in the consolidated table, the same date could appear for two or more cashflows, so in these cases, the instances of that dates should all present tha same same IRR.
Many thanks in advance!
Francesco
how can I implement the XIRR formula direcly in a pivot table?
What I need is to represent in a pivot chart the IRR calculted at every reference date for the selected investments (throuhg a slicer). All of this, considering that in the consolidated table, the same date could appear for two or more cashflows, so in these cases, the instances of that dates should all present tha same same IRR.
Many thanks in advance!
Francesco