Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Issue with partial sub total but able to get peak sold qty, please help me on the below expression. thanks
Peak sold qty
=If(Dimensionality()=1,
max({<Week_No=,Week_No,Batch,ArticleNo>} aggr(sum({<Week_No=,Week_No,ArticleNo>}Sold_Qty),Week_No,Batch,ArticleNo)),
max({<Week_No=,Week_No,Batch,ArticleNo>} aggr(sum({<Week_No=,Week_No,ArticleNo>}Sold_Qty),Week_No,Batch,ArticleNo))
)
try
sum(aggr(max(Sold_Qty), ArticleNo, Batch))
Hi,
Try this.
Sum(Aggr(max({<Week_No=,Week_No,Batch,ArticleNo>} aggr(sum({<Week_No=,Week_No,ArticleNo>}Sold_Qty),Week_No,Batch,ArticleNo)),ArticleNo,Batch))
Regards,
Kaushik Solanki