MDX help - Sum of prior quarters
SummaryMDX help - Sum of prior quarters
Could you please light on the below ASO member formula request.
Need a formula which should be a sum of @idescendants (Accoun1) in Q2 - sum of @idescendants (Account 1) in Q1 (previous quarter).
Currently I have tried the below formula on "ACCOUNT 2" but its taking more than 6 mins when executing from smartview (validation sheet contains quarters for 2 years, ie 8 quarters).
Also I have used a higher Solver Order for Account 2 as 20 which is the highest in the current outline. Also "Account 1" is just a Parent for shared account members under it.