Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. 🙂
Can u please give us sample data?
Maybe 5 lines of data with the expected result?
It will be so much easier 🙂
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!
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
@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. 🙂
@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. 🙂
Apologies, how is the customer share calculated? i don 't understand how Customer 1 is 10% of the share?
I hope this table makes it clear now. 🙂