Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to show 20 accounts in dimension 'm' showing in pivot where
Qualifier 1:sales for FY17 >'1'
Qualifier 2:Profit is negative (bottom 20 accounts) corresponding to YTD FY18
Pfa of the qvf attached.
I believe this should work for you:
Define the dimension M with this expression
=Aggr( Only(
{$<M={"=
Sum({$<[Fiscal Year]={$(=$(Previous_to_max_year))},Quarters=>} Sales) > 1
AND
(Sum({$<[Fiscal Year]={$(=$(max_year))},Quarters={$(=$(ytd_prev_year_quarter))},[Month Name]={$(=$(ytd_prev_year_month))}>}Profit)/ Sum({$<[Fiscal Year]={$(=$(max_year))},Quarters={$(=$(ytd_prev_year_quarter))},[Month Name]={$(=$(ytd_prev_year_month))}>}Sales))
< 0
"}>}M),M)
Hi Petter,
I want to limit my bottom accounts to 20. Where can I change it in the expression?