You use the Parent() navigation method, when you want to reference a parent node in the hierarchy.
This is exemplified below.
From the current node, you navigate up one level of the hierarchy. If the data is not hierarchical, or the current node is at the top level, the Parent() method works in the same way as the All() method.
The bar chart below presents absolute sales figures for a number of products. The products have been structured hierarchically on the category axis.
Assume you want to display each fruit type's share of the total fruit sales, and each vegetable's share of the total vegetables sales. Then you need to reference the parent nodes. Apply the expression below (and format the values as percentage on the Value axis):
The expression divides each fruit's sales amount by the total fruit sales, and each vegetable's sales amount by the total vegetables sales. For example, from the Bananas sales, the Parent() method navigates up to the Fruit level to retrieve the total sum of fruit. The ratio is 1012/(465+1012+812) ≈ 44.2%.
Using a different version of Spotfire?This help describes the web client version of Spotfire on TIBCO Cloud™. If you're looking for documentation for the installed client or other versions of Spotfire, visit the TIBCO Documentation Portal.