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.
=[Total Complaint] /
sum( TOTAL<MainArticle> aggr(if([Item number]<>MainArticle ,' ',Sum ( InvoiceQty)),[Item number]))
Retrieving data ...