Divide value by the total of the column and compare

[nesonica]

Hi guys,

I have a column field named "category"

in this "category" i have the values: "good", "medium", "bad".

1)

I want to see how high the share of the "category" is per each dimension "customer" in percent ("good" 30%, "medium" 60%, "bad" 10%)

2) 

Then I want to compare the share of a customer ("good" 30%) compared to the average customer ("good" 70%) and give the text information "the customer x is y % below average in the category z)

I hope I did not express it too complicatedly. Thanks in advance and sorry for the bad wording. 🙂

[OmarBenSalem]

Can u please give us sample data?

Maybe 5 lines of data with the expected result?

It will be so much easier 🙂 

[nesonica]

In column A we have the customer, in column B we have the Product Category, in column C we have the Sales.

In column D I would like to have the share of this Category at customer level. (e. g. 10% in "17 DUSCHABTRENNUNGEN", 90% in "18 OTHERS")

In column E I would like to have the difference compared to the average customer. (e. g. 15% less)

In column F I would like to have the text: "15 % less in category 17 DUSCHABTRENNUNGEN")

I hope that is more clear now 🙂 Thank you!

[hopkinsc]

Hi,

Can you enter some rows of data in an inline load in a  QVW and post it please? You haven't shown all of the rows in your screenshot so we can't see Others for example.

Or attach an excel export

[dplr-rn]

Something like
Sum(Sales)/Sum(Total <Customer> Sales )
?

[nesonica]

---

@hopkinsc wrote:

Hi,

Can you enter some rows of data in an inline load in a  QVW and post it please? You haven't shown all of the rows in your screenshot so we can't see Others for example.

Or attach an excel export

---

I hope this Excel can help make my plan more clear. 🙂 

[nesonica]

---

@dplr-rn wrote:
Something like
Sum(Sales)/Sum(Total <Customer> Sales )
?

---

something like this, yes 🙂

but this gives me only the customer sales share from total

i wanted

the customer sales share of a category to customer sales share of all categories (one customer)
/
the customer sales share of a category to customer sales share of all categories (all customers)

>> this shall show me, if a specific customer is concentrating less on a specific category than the average customer. the hypothesis is, that every customer usually needs a specific share of products in a category. 🙂

[hopkinsc]

Apologies, how is the customer share calculated? i don 't understand how Customer 1 is 10% of the share?

[dplr-rn]

not clear what you need.
Can you add the calculation in the excel? as formula

[nesonica]

I hope this table makes it clear now. 🙂