Hi, i could use a bit of help trying to make a graph that shows how a configuration that sells for diffrent prices in diffrent locations affects the revenue example:
Store 1 Sells Addidas pants for 10$ and sells a total of 100 pants
Store 1 Sells Addidas pants with stripes for 10$ and sells a total of 100 pants
store 2 sells addidas pants for 15$ and sells a total of 30 pants
store 2 sells addidas pants with stripes for 12$ and sells a total of 30 pants
store 3 Sells addidas pants for 9$ and sells 10 pants
store 3 Sells addidas pants with stripes for 4$ and sells 10 pants
store 4 sells addidas pants stripes for 11$ and sells 9 pants
store 4 sells addidas pants with stripes for 19$ and sells 9 pants
and so on
i want to see on the graph how manny % of for example Addidas pants in all stores (eventhou they sell for diffrent prices) how manny % they are of total sell
the dimensions i have are following
Panttypes ( Addidas pants and Addidas pants with stripes)
Stores
Retail price ( prices of each type of pant)
i made this: num(sum([panttypes])/sum(total [Retail Price]), '##,##0%') it shows all items sold in 1 store and how that store affects total revenue if i choose all stores.
