Sum Calculation

[#1]

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.

[swuehl · Accepted solution]

Try

=[Total Complaint] /

sum( TOTAL<MainArticle> aggr(if([Item number]<>MainArticle ,' ',Sum ( InvoiceQty)),[Item number]))