Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
i would like to show the percentage calculation of the article No per MainArticle without Selecting the dimension Main Article as in the picture below the first.
is it poosible to calculate on partial total?
attached is the qwv.
Try
=[Total Complaint] /
sum( TOTAL<MainArticle> aggr(if([Item number]<>MainArticle ,' ',Sum ( InvoiceQty)),[Item number]))
Try
=[Total Complaint] /
sum( TOTAL<MainArticle> aggr(if([Item number]<>MainArticle ,' ',Sum ( InvoiceQty)),[Item number]))