Hello, everybody,
I will display all articles that have been sold.
Now I would like to create a sales rank.
The article with the highest paragraph should be on place 1 and the article with the lowest paragraph on the last place.
does anyone have any idea how I can calculate something like this?
Gruß Mücke
Hello, everybody,
I have not received an answer yet :-(.
Maybe my question is formulated incomprehensibly, I will try again.
I would like to show all items that have been sold.
Now I want to create a sales rank.
The article with the highest paragraph (number of pieces) should be on place 1 and the article with the lowest paragraph (number of pieces) on the last place.
(Articles do not have to be sorted! Rank must be correct)
Does anyone have any idea how I can calculate such a rank?
In Excel I do it like this:
=Rank(A2; A:A; 1)+COUNT($A$1:A1;A2)
How can I upload an Excel spreadsheet?
unfortunately only a picture of the table
Question: How can I realize this in Phocas?
Gruß Mücke
How is this different to just adding quantity sold as a measure and sorting by that?
I want to create a placement so that my customers do not receive sensitive data.
Example:
Column 0 = article numbers
Column 1 = Rank by number of pieces (from a whole country)
Column 2 = Rank by number of pieces (only from customer)
So for me and my customers it is obvious which items are doing well compared to the country and which items they don’t have with them.
So the customer can decide whether or not he wants to have items that are sold in his country still in stock or not.
But I do not want to tell my customer how many pieces of an item I have sold.
I hope it has become somewhat understandable, if not, I am happy to give feedback.
