Forum Discussion
Average SKU per Invoice calculation
Hello All, I need help calculating the average SKU per invoice, the calculation of which is= (SKU Sold Per Invoice X No of Invoices)/Total No of Invoices I have a transaction table with invo...
Hi
Anonymousyou need to create a calculated table which returns the table you're showing below. Then drop the SKU Count on the rows section of a matrix and add a measure which does COUNTROWS( <the_calculated table_you_created> )
LivioLanzo
Solution Sage
Solution SageHi
Anonymous
you need to create a calculated table which returns the table you're showing below. Then drop the SKU Count on the rows section of a matrix and add a measure which does COUNTROWS( <the_calculated table_you_created> )