Forum Discussion
Select the x accounts who are visited the longest time ago with extra filters
Hi all, I want to make a report in excel that gives me a list of the (by example) 20 accounts who are visited the longest time ago. That works fine with the following formula: =INDEX('10 Acc...
See, you could have moved on with your life after inserting that simple pivot table 😛
JKPieterseBut it wouldn't be the report I want 🙂
This is just a small part of a very big report! I should combine more then 30 pivots on one sheet to show the same info. Therefore I choose to use formulas instead of pivot's
Also to update the data,... I don't need to refresh the pivot tables, only click 1 button of an add-in with salesforce to retrieve all the new data.
Those 2 reasons make me choose that formulas are better (for this report) then pivots. I use pivots, but only to show data in a quick easy way, without formatting the way management it want to see.