Forum Discussion
Advocate IIHierarchies- need some help
I have sucessfully created a drill down for heierarchies, which works fine.
but my data is available at each level of the hierarchy
as such my graph sums, or averages (depending on what is set) all the values for all levels in the hierarchy,
so at the top level i get the sum or average of all the levels in one value
Is there a way to not get it to sum up the levels and just display the values for that one level
thanks john
6 Replies
- austinsense
Impactful Individual
It's hard to understand exactly what your issue is - maybe show a screenshot?
docjohnI have a table which contains a value for all my locations.
each location has a value
the locations are placed in a hierarchy and i have build a graph that drills down through the different levels
it works, but it sums or i my case averages the values
as it is averaging all the values under the hierarchy structure, it does not give the value for that location
example
l1 3.5
l2a 3
l2b 3
l2c 4
the l1 value seem to be the average of all the values rather than 3.5
hope this clarifies
Note the size o fthe location differ so an average is not really any use
Hello docjohn
If I'm right, you want to see the numerci value on each level of your hierarchy without aggregation function, that's it?
I guess you cannot do it because drill down chart needs a aggregate value to display the item.
I think, the only way to do this (i.e : display the value belonging to the level) is to use the value concatenat with the level.
If I get you example, it will show :
Name / Value / New column
I1 / 3.5 / I1-3.5
I2a / 3 / I2a-3
I2b / 3 / I2b - 3
I2C / 4 / I2c-4
But unfortunately it going to be hard to use the new column as location. Sorry not to find a better solution. Hope it helps anyway.
Sébastien
