Forum Discussion
Top n vs. Others in Excel
Playing a bit more with PIVOTBY arguments allows sorting the TOP Brands in Descending order according to their Total. This eliminates a +/- complex & unnecessary calc. step
Updated version attached (crossing fingers it'll persist…)
Lz.
Hi
2 days with no reply probably means nobody's ready to re-create existing data (takes time), running the risk it doesn't reflect yours ==> Suggest you share your workbook (anonymized) with OneDrive, Google Drive or the like
Also, please mention the version of Excel you run and on which platform (Windows, Mac, Web...)
Hope this all makes sense
Hi Lorenzo,
Thank you so much for guiding me on this platform. I'm kind of new here and don't quite know how things operate on this forum. I'm not sure if my previous reply to you went through because it isn't reflecting on my end but, I've managed to update my original post to reflect what you've suggested.
Thank you so much once again, I greatly appreciate it!