Hi All how to populate data for lower level record based on upper level of granularity ?

[shekhar_analyti]

Hi All ,

Hi All how to populate data for lower level record based on upper level of granularity ?

But i want to filter those SSN which are reporting to someone and few others are reporting to those SSN as well . For these SSN , Zone does not exist , but i want their Zone be populated as Zone of the person , whom these SSN are reporting to

Please find attached excel sheet with data and output required .  I have output1 and output2 as well .

Thanks & Regards

Shekar

Message was edited by: shekar shekhar

[sunny_talwar]

Join and ApplyMap should still work... can you share the script that you are using right now?

[shekhar_analyti]

Hi Sunny ,

When i am selecting i am getting correct aggreagted value in table for 124 , but Zone value gets wronged , when i am unselecting 124 , zone value is correct but aggr value gets wrong

[sunny_talwar]

Like I mentioned, you need to use Hierarchy function here... not really good with it, but tried here a little. The result is not perfect, but see if you can play around with it to make it work for yourself