User Tools

Site Tools


bicn01:f5010

PowerPivot: Product Mix

Create a PowerPivot query

Rows Values
Product_Category Sum of Stock_Amount
Sum of Sales_Amount

In the context menu of both measures, set value field setting, in the show values as to % of Column Total

Your query should look like this:

bicn01/f5010.txt · Last modified: 2018/12/04 08:39 (external edit)