• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate IRR direcly in a pivot table in order to use slicers and use a pivot chart in a dashboard


New Member
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!