Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two excel files contains tablesTab1, Tab2 AS follows
Tab1:
Staffing Profile Identifier | Project num | Project Name | Demand Resource |
707963 | 220981 | QV_Dev | 4 |
707964 | 209892 | QV_Dev | 6 |
707965 | 209892 | QV_Dev | 5 |
Tab2:
Profile Identifier | Project Name | Allocated Resource |
707963 | QV_Dev | 1 |
707963 | QV_Dev | 2 |
707964 | QV_Dev | 3 |
707964 | QV_Dev | 2 |
707965 | QV_Dev | 3 |
But Output will be in PIVOT or STRAIGHT TABLE as follows
Profile Identifier | Project Number | Project Name | Demand Resources | Allocated Resource | Gap |
707963 | 220981 | QV_Dev | 4 | 3 | 1 |
707964 | 209892 | QV_Dev | 6 | 5 | 1 |
707965 | 209892 | QV_Dev | 5 | 3 | 2 |
i tried it using if((Staff Profile Identifier=Position Identifier),Allocated Resource,0) in Expression and i used calculated dimension also, but sometimes it works well and some times got errors.
Please Find attached Screen shots.
PLEASE Can any one look into issue, GIve me Solution.
Thanks,
MVReddy.
We can achieve this using simple Join. (Join on Profile Identifier)
I have done the bellow process.
1. Load the first tab
2. While Loading the second tab use the "Group By" and "Sum" functions.
3. In chart, use the expression as "=Demand-Actual"
Thanks Wassenaar,
It's working fine now.
Thanks for your support.
Thanks,
VAmsi