i have powerpivot table looks this:
product, units_sold, year 10 1990 5 1990 b 12 1900 c 50 1900 i want create calculated field contribution overall sales of each sale, e.g. in case divide every number 77.
how can in powerpivot?
use formula calculated column:
=[units_sold]/sum([units_sold]) rename column , choose formatting home menu.
Comments
Post a Comment