Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Frnz,
I would like to display Sum of Top 2 Accounts in year wise. Here, in every account has some values(L4AMID_VALUE_USD). I would like to calculate sum of these values and apply Top 2 on these account names. And Finally i want Sum Of Top 2 accounts.
Please find the attached QVW.
Try below expression
sum(aggr(if(rank(sum(L4AMID_VALUE_USD),4)<=2,sum(L4AMID_VALUE_USD)),YEAR, L4ACCTNAME))
Try below expression
sum(aggr(if(rank(sum(L4AMID_VALUE_USD),4)<=2,sum(L4AMID_VALUE_USD)),YEAR, L4ACCTNAME))
May be this:
sum(If(Aggr(NODISTINCT Rank(Sum(L4AMID_VALUE_USD)), L4ACCTNAME) <= 2, L4AMID_VALUE_USD))
It should be
2015 26
2016 53
2017 50
Yes, My expression gives this result
It certainly does
I think you are missing YEAR in aggregation
sum(If(Aggr(NODISTINCT Rank(Sum(L4AMID_VALUE_USD)), YEAR, L4ACCTNAME) <= 2, L4AMID_VALUE_USD))
Hahahaha ya that seem to did it Not on top of my game today.
Day just started.. Long way to go for you.. Mine already half way
Hi Frnz,,
Thanks a lot. All have given right expression. It is working..