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.