Percent of sales

@PARENTVAL("Account"

Summary

Percent of sales

Content

Hi Experts,

I have a scenario where Budget and Percent_of_sales are scenario members, and the requirement is Percent_of_sales should be calculated from budget for every account member by Parent3 member of account dimension as shown below.

                 Budget   Percent_of_sales

Parent1     3000    Parent1/Parent3;

A1             1000       A1/Parent3 

A2             1000       A2/Parent3

A3             1000       A3/Parent3

Parent2      3000    Parent2/Parent3;

A4             1000       A4/Parent3

A5             1000       A5/Parent3

A6             1000       A6/Parent3

Parent3      6000    

I have written the formula as below

Percent_of_sales = "Budget" / @PARENTVAL("Account","Budget");

But it is calculating from its immediate parent(Ex:- A1/Parent1,  a4/Parent2) but all the members need to be divided by Parent3 member.