Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello Dears
1-I want find Top 5 Selling Product (Sum(SaleAmount))?
2-i want find largest Product Per SubCategory (Sum(SaleAmount))
Look Like
plz help me
Hi,
Can you try this in your Expression...
=if(rank(Sum(SalesAmount))<=5,sum(SalesAmount))
PFA
Regards
Sam
Try the below logic:
In calculated dimension
=AGGR(IF(Rank(sum(SalesAmount), 4)<=5, EnglishProductSubcategoryName), EnglishProductSubcategoryName)
with the same expression
Regards,
Kavita
Thanks
now if want find worst Sum(SaleAmount) Per Subcategory ?How
Thanks
now if want find worst Sum(SaleAmount) Per Subcategory ?How
Hi,
Try like this
Dimension: EnglishProductSubcategoryName
Expression:=Aggr(if(rank(-sum({<SalesAmount ={'>0'}>}SalesAmount)) <= 5, sum({<SalesAmount ={'>0'}>} SalesAmount)),EnglishProductSubcategoryName)
Regards,
Jagan.
i try but Expression Is Not Valid