Forum Discussion
SeafoodDutch
Dec 05, 2023Copper Contributor
Counting Invoices when there are duplicates
I have a data set that has a listing of multiple invoices with the invoice number repeated because the data also had the product that was sold. I need to generate a report, for each month of the yea...
Lorenzo
Dec 30, 2023Silver Contributor
Fair enough. Just be aware that PowerPivot is designed to deal efficiently with large amount of data
SeafoodDutch
Dec 31, 2023Copper Contributor
I'm uncertain about your comment.
A 20 MB file isn't a large file in your estimation?
A 20 MB file isn't a large file in your estimation?
- LorenzoJan 03, 2024Silver Contributor
Everything is relative 🙂 One could consider 20 Mb as a large file, someone else as a regular file
My point was only to say that even if you have a large amount of data, Power Pivot could be an option