summation on the basis of results that getting from precalculated formulae (Total function )

[deep2021]

Hi,

I am getting right results by using the below formula,

(Sum(Total<Dim_1,Dim_2,Dim_3>sales)
/
Sum({<Dim_2=,Dim_1=>}Total<Dim_3>sales)
)* (Sum(Total<Dim_1,Dim_2,Dim_3,Dim_D>{<flag={'P'},Period*={'Current Year'},date *= {"$(=max(date))"}>}sales)/
Sum(Total<Dim_1,Dim_2,Dim_3,Dim_D>{<Period*={'Current Year'},date *= {"$(=max(date))"}>}sales))

Now, I need summation of the results getting from above formula w.r.t Dim_D and Dim_3 (group by Dim_D and Dim_3).

I want to use Total<Dim_D ,Dim_3 > for the output on the basis of above formula.

The final expression I need to like below,

sum(Total<Dim_D ,Dim_3 > above expression)

Can you please suggest on this?

thanks

[deep2021]

Hello experts,

can you please suggest on this?

thanks

[vinieme12 · Accepted solution]

Use AGGR(), as below

=SUM( AGGR (

(Sum(Total<Dim_1,Dim_2,Dim_3>sales)
/
Sum({<Dim_2=,Dim_1=>}Total<Dim_3>sales)
)* (Sum(Total<Dim_1,Dim_2,Dim_3,Dim_D>{<flag={'P'},Period*={'Current Year'},date *= {"$(=max(date))"}>}sales)/
Sum(Total<Dim_1,Dim_2,Dim_3,Dim_D>{<Period*={'Current Year'},date *= {"$(=max(date))"}>}sales))

,Dim_D,Dim_3 ) )

[deep2021]

Hi Vineet,

Thanks for the reply. But this is not showing the correct results.

Thanks

[vinieme12]

can you post a sample app with dummy data?

[deep2021]

Total function with above function is working fine for me.

thanks