Get value of immediate Parent of page selector

Options
akmehta91
akmehta91 Member, ALL USERS Posts: 1 New Contributor
in Planning & Modeling

Hi, 

 

The list hierarchy defined is Category > Brand > Sub-brand > SKU

When the page selector is selected, how can we dynamically get the total value of its immediate parent ?

 

For example,

if SKU is selected, the value should be of total of Sub-brand level.

If Brand is selected, the value should be total of Category level

 

The reason is to get % of total (of immediate parent) to calculate sales mix at different levels of hierarchy 

 

Thanks.

 

Tagged:

Categories