Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Members,
I have the following issue:
I want to create a Chart as a table with a Dimension, which gives me the turnover rate for the last 12 months as a letter.
Actually I have two tables. One with Information about the article and one with all stock movements of every article. With both I am able to say, what is the stock in this Moment and was the stock a month ago. I´m also able to say, what is the turnover rate of each article, when the article is the Dimension.
For Example:
Article | Turnover Rate |
---|---|
55555 | 12,00 |
44444 | 11,59 |
The Problem I have is, that I want to find out, how many article´s have a turnover rate between x and y and how many between y and z and so on...
So i would like to have the following solution:
Turnover Rate | Count(Artikel) |
---|---|
X | 5 |
Y | 10 |
Z | 60 |
I hope, anybody could help me.
Thanks a lot.
Take a look to Rank function ...
Thanks for your response, but i didn´t find something helpful for this issue. May be it´s because I am no data analyst specialist.
But I tried something easier...
In the table with the stock movements, there is column with amounts. So when I say ' sum(Amount), I will get the stock of this moment. When I tried this in a dimension i only get an error '//error in the dynamic dim...'
= if (sum(Amount) > 0, 'article with stock', 'article without stock')
So obviously it doesn´t work...
Could you send me the qvw???
I send you an email