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.

[jagan]

Hi,

Can you attach the sample file?

Regards,

Jagan.

[swuehl]

Not sure what you've done to your other thread, but AFAIR I tried to answer your question there.

No multiple posts regarding the same issue, please, it makes it hard to follow a discussion.

[Gabriel]

Hi,

Experts here will love to help resolve this issue. However, you have not provided enough explanation, i.e. what result you want, what the issue is? e.t.c

Kindly provide more information.

From what I can glean from little inforamtion you provided above, it sounds as if you wanted to join both TABS (TAB1 & TAB2) together. If that's the case. I will suggest you use JOIN functionality.

Hope this help and look forward to more explanantion

Best Regards,

Gabriel

[#5]

Please Respond Anyone to this issue, It's Urgent Requirement!

Thanks To All for Your Valuable Reply,

Now i'm attaching sample QVW and my requirement is 'Position IDentifier' repeated and taking 'Allocated Resources' values repeatedly, but i want only one 'Position IDentifier' value for this i want to add multiple 'Allocated Resources'(Belongs to same 'Position Identifier') and substract them with 'Demand Resource(it's a single value)'

it's Urgent Requirement, i'm waiting for your reply.

Please Respond Anyone to this issue, It's Urgent Requirement!

Thanks,

Reddy

[#6]

I Added Explonation and sample QVW and Screenshots.

Please give any idea on this.

It's Urgent Requirement.

Thanks,

MV Reddy

[#7]

Hi swuehl,

I'm sorry about that and now my requirement has been changed thatswhy i posted in Post.

Please look into the issue, it's Urgent.

Thanks,

MV Reddy

[Gysbert_Wassenaar]

See attached example

[#9]

Thank you very much Gysbert Wassenaar,

This is exactly what i needed, It's working fine but in my QVW for some values i'm getting Error values like "-5.5511151231258e-017", "2.2204460492503e-016", " -4.4408920985006e-016".... ,i attached sample screen shot also.

Rest of all things are working fine. 

i tried to replace them with '0', but it didn't work.

I'm attaching my QVW, Please have a look into this issue.

Thanks for your valuable support to us.

Thanks,

MV Reddy

[Gysbert_Wassenaar]

Try using the round or floor function: for example round(AllocatedR-Demand,0.001)