 Rank: Member
Groups: extranet\Forum
Joined: 7/18/2018(UTC)
Posts: 7
|
Hi,
Is there a way to show a calculation which is based on dimension values?
I have a item tabel showing all our Items and a item code.
How can I make a new calculation (rows) on how many Item numbers is showing in the different categories?
Item(d) Item Category Code(d) Gross Sales(m1) Quantity(m2)
9274 AA 100.000 20
9275 AB 20.000 10
9276 CA 5.000 20
Number of AA 1
Number of AB 1
Number of CA 1
Thanks in advance.
BR.
Morten
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/12/2019(UTC)
Posts: 41
|
Hi Morten
Maybe I misunderstand your question, but have you tried count instead of sum?
BR
Lotte
|
|
|
|
|
|
Rank: Member
Groups: extranet\Forum
Joined: 7/18/2018(UTC)
Posts: 7
|
Hi Lotte,
Yes, but how do I count the number of how many times item's appear based on the different Item Categories, which is listed as a dimension?
Hope it makes sence :-)
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/12/2019(UTC)
Posts: 41
|
Hi Morten
Maybe it would be clearer with a screenshot ;-)
BR
Lotte
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.