Reputation: 3
Started my BI journey two days ago and got stuck with this “issue”.
I have a fact table representing order intake (consists of invoices and sales orders related to a project -multiple rows with same project) and an additional fact table representing projects (dates, budgets, actual ect)
So i would like to group and sum the order intake pr. Project and by project sales and current-forecast margin (table 2).
Resulting In a KPI card showing total order intake amount and corresponding sales and forecast %
Hope it makes sense
Thought abount merging to one table - but from what i Read this is not recommended
Upvotes: 0
Views: 40