en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Morten Nielsen  
#1 Posted : Friday, June 28, 2019 12:39:29 PM(UTC)
Morten Nielsen
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
Lotte Bjørn Jensen  
#2 Posted : Friday, June 28, 2019 1:07:59 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/12/2019(UTC)
Posts: 24

Hi Morten

Maybe I misunderstand your question, but have you tried count instead of sum?

BR
Lotte
Morten Nielsen  
#3 Posted : Monday, July 1, 2019 8:49:33 AM(UTC)
Morten Nielsen
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 :-)
Lotte Bjørn Jensen  
#4 Posted : Tuesday, July 2, 2019 11:54:41 AM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/12/2019(UTC)
Posts: 24

Hi Morten

Maybe it would be clearer with a screenshot ;-)

BR
Lotte

Users browsing this topic
Anonymous
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.

Notification

Icon
Error

We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.

ok