-
1. Re: How to aggregate a measure within a hierarchy?
Deepak RaiFeb 23, 2017 7:49 PM (in response to Romit Mehta)
1 of 1 people found this helpfulHi Romit,
If you are looking for this thing for Level 2 and Level 1, see screenshots and attached.
Level 2
Level 1
Thanks
Deepak
-
2. Re: How to aggregate a measure within a hierarchy?
Romit Mehta Feb 24, 2017 2:06 PM (in response to Deepak Rai)I wasn't able to open the attachment because it seems to be from a version later than what I have (10). Not sure why.
But yes, that's exactly what I'd like to see, as you have shown in your screenshots.
-
3. Re: How to aggregate a measure within a hierarchy?
Deepak RaiFeb 24, 2017 2:20 PM (in response to Romit Mehta)
1 of 1 people found this helpfulHello Romit,
My file is in 10.1. If you upgrade to 10.1 you would be able to open it, but these are the calculations which you can use to achieve it , in case you are again not able to open it.
As you have got what was desired, please don't forget mark the Reply as Helpful and CORRECT to close Discussion.
You can always ask additional questions.
Thanks
Deepak
-
4. Re: How to aggregate a measure within a hierarchy?
Romit Mehta Feb 27, 2017 2:28 PM (in response to Deepak Rai)Thanks, I played with that calculation and realized that it is not exactly doing what is desired.
What I'm trying to do is create a dynamic calculation based on the level of hierarchy shown in the viz. So if I have it collapsed all the way at Level 1, then show the calc for color aggregated to Level 1. However, if I expand down to Level 2, then the calculation should calculate the color for Level 2, but as I see, it is not doing that, and instead it is showing the Level 1-applicable color for all Level 2 items regardless of their % complete.
This is kind of a cube-philosophy that I am used to so pardon me but is something like that do-able at all?
-
5. Re: How to aggregate a measure within a hierarchy?
Romit Mehta Feb 27, 2017 4:26 PM (in response to Deepak Rai)Thinking more about it, I can see that this may be an impossible ask. The reason being, I am looking at Story % complete to calculate the Level 2 color, but I am looking for a completely different calculation for Level 1 color, which is "take the least performing Level 2 and show its color".
Let me know if this is possible at all:
For all dimensions except Level 2, calculate the color as "lowest" of all Level 2's and for any Level 2, calculate it based on the % complete for the Story included in each Level 2.
-
6. Re: How to aggregate a measure within a hierarchy?
Deepak RaiFeb 27, 2017 6:36 PM (in response to Romit Mehta)
Hi Romit,
I am sure this was the best I Could do for your question. May be someone else will pick it up from here.
Thanks
Deepak