Skip to Content
0
Mar 10, 2009 at 12:49 PM

Suppressing aggregation in Hierarchy

36 Views

Hi,

Hi,

We are getting following data from ECC for WBS

WBS_____________Cost_______POC(%)

-


WBS1____________ 00_________40

WBS1.1___________70_________60

WBS1.2___________50_________20

Requirement is to show cost & POC along WBS hierarchy

WBS________________Cost_______POC(%)

-


WBS1_______________120________40

|--->WBS1.1___________70_________60

|--->WBS1.2___________50_________20

When we are creating report, it is basically aggregating all values of WBS 1, 1.1 & 1.2 like following

WBS________________Cost_______POC(%)

-


WBS1_______________120________80

|--->WBS1____________ 00_________40

|--->WBS1.1___________70_________60

|--->WBS1.2___________50_________20

In this we can hide WBS1 in the leaf node, but still problem remains with WBS1 in the parent node showing aggregated value (80) instead of actual value (40).

Has anyone done like this before? Appreciate your help...!!!

Thanks & Regards,

Vikram.