Sub Totals

[#1]

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.

[PradeepReddy]

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"

[#3]

Thanks Wassenaar,

It's working fine now.

Thanks for your support.

Thanks,

VAmsi