Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ) )
Hello experts,
can you please suggest on this?
thanks
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 ) )
Hi Vineet,
Thanks for the reply. But this is not showing the correct results.
Thanks
can you post a sample app with dummy data?
Total function with above function is working fine for me.
thanks