![]() It's unfortunate because I try to support OSS as much as possible. As well, the pivot tables in Excel are in a totally different league than LibreOffice in terms performance and flexibility. LibreOffice absolutely chokes when I try to do any filtering or calculations. Just a few days ago I was poking around the Himalayan Database and one of the tables has about 50K records. where there is no Excel, so I use LibreOffice instead. ![]() You might have to wait a few seconds based on what you were trying to do, but Excel could handle it.Īt home I run Linux. but what was nice was being able to grab 600K records (maybe 20 cols) from a DB, throw it in Excel and get some results in a matter of minutes. Needless to say, I became very accustomed to and adept with using Excel. I used to work in an insurance company on an actuarial pricing team where the preferred tool was Excel (the modelling was pretty simple). but I'm unfortunately stuck with LibreOffice. My problem is there is not Left Join in power query.Excel is a piece of software that I would absolutely not hesitate to pay for. I am sure there is a better way to do that but this is the only way I can think of. Then I could do a left outer join with a counts table (The counts table would be created by grouping the offer data by rep name then offer type) where it checks for matching rep name and offer type, then if it does not have a match, it would just put null in the new column. ![]() ![]() What I was thinking to do is what in SQL would be a left join when for each rep it will add a row for each offer type. I know I can do a group by Rep and offer then that will give me a count for all of them except if a rep has not made any of a singe offer. What I would like is a new query that takes the list of offers and shows me how many of each type of offer each rep is making. Then I have a second query showing all the offer types. I want to see how many of them are doing each kind of offer.įor my data, I have a query showing every offer made that contains the reps name and the offer type. I am working on a project for sales where there are 4 types of offers and every rep should be making each. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |