When refreshing all I receive the following error
A circular dependency was detected: 'Trans'[CostBasisimpactRpt3],'Trans'[CostBasisimpactRpt3],'Trans'[CBBuyToDateRpt3],'Trans'[CBCycleNo],'Trans'[CostBasisimpactRpt3].
I'm using excel 2016.
This is my first time using Portfolio Slicer so hopefully a simple problem to fix.
rick
Comments
Rick
I am glad you fixed this issue. Usually you get this type of error when you have sell transaction before you have buy transaction - so cost basis cannot be properly calculated.