Skip to Content
0
Former Member
Mar 09, 2006 at 11:11 PM

Hierarchies in Reporting

57 Views

Hi All,

I created a query with a field that has hierarchy. When i drilldown the hierarchy the query repeats the values of the rest of the fields for every node of the hierarchy even though the data is associated only with the lowest node. Is there a setting or something that will prevent the data from repeating at every node.

-


This is how the data is displaying:

Territory Contact Expected Sales

Global CHARCHENKO $ 45,656.00

gilbert $ 5,000.00

Result $50,656.00

-Americas CHARCHENKO $ 45,656.00

gilbert $ 5,000.00

Result $ 50,656.00

-North Americas CHARCHENKO $ 45,656.00

gilbert $ 5,000.00

Result $ 50,656.00

-United States CHARCHENKO $ 45,656.00

gilbert $ 5,000.00

Result $ 50,656.00

-North West CHARCHENKO $ 45,656.00

gilbert $ 5,000.00

Result $ 50,656.00

-


I want to be able to drilldown but see the data from the remaining 2 fields only at the lowest level and not at every level.

Any help is appreciated.

Thanks,

Raj