I'm using Portfolio Slicer v3.1 and the Grand Total for my "Profit %" is completely broken, showing -3,564.39%.
The individual asset rows calculate correctly (my actual total profit should be ~4.12%).
You are likely have 1 symbol that makes total calculation unreliable. To figure out symbol, go to "Mhtly-Symbol" worksheet. Make sure that "Year" slicer is cleared (nothing selected). From the right slicer select symbol by symbol and review results. You likely will see one symbol providing unreasonable calculations - investigate that symbol transactions.
Comments
You are likely have 1 symbol that makes total calculation unreliable.
To figure out symbol, go to "Mhtly-Symbol" worksheet. Make sure that "Year" slicer is cleared (nothing selected). From the right slicer select symbol by symbol and review results. You likely will see one symbol providing unreasonable calculations - investigate that symbol transactions.