Hi Guys,
I've attached an example workbook to help explain what I need.
I've basically got two set of data
1/ the left data source will be a long list of transactions per company, so there will be multiple rows of data per company.
2/ the right data source shows the budget per company, so there will only be one row per company.
Ultimately I need a master list of data with one line per company, showing total rev, gp and budget rev and GP.
I managed to set up a formula that will lookup and enter the budget only once per company, which allows me to pivot my data successfully.
Heres where my problem lies - there will be companies in the right hand data source (Company A and Company B) that don't appear in the left hand data source and I want these companies to appear in the new list/pivot (with 0 rev & GP)
I hope that made sense, i've tried to explain it the best I could.
Any help is much appreciated.
Thanks,
Bookmarks