Forum Discussion
Solved
Active / Projected project count
Hello Community, I have two tables (Active and Projected) one table shows the count of projects that were projected and the "Active" table will give the count of projects that are active. I would...
Client, Portfolio and Year should be independent dimension tables connected to both fact tables. Then simple DIVIDE of the SUM's shsll do the job.
Client, Portfolio and Year should be independent dimension tables connected to both fact tables. Then simple DIVIDE of the SUM's shsll do the job.