Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
phu viet pham  
#1 Posted : Monday, April 4, 2016 2:45:14 PM(UTC)
phu viet pham
Rank: Newbie

Groups: extranet\Forum
Joined: 1/26/2016(UTC)
Posts: 1

Hi every one,

i have data as follow:
Customer Order ID
A 12
A 13
A 14
A 15
B 16
B 17
B 18

then i want to calculate the number of order per each Customer. and the result i would like to have is:

Customer number of order
A 4
B 3

i think the calculation should be simple but i tried many Calc but i don't get the correct result. Can you please help me with the Calc?

Páll Bjarkason  
#2 Posted : Wednesday, April 6, 2016 1:40:56 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 158

Hi phu viet pham

In a costumer dimension with members a and b; a and b are siblings.
If OrderID also is a dimension with ID’s, then it is possible to count the dimension members.

The Costumer and OrderID dimensions are nested, using the table object type. Using the table object type does not require a measure. All is good and these little calculations count the number of members and siblings in the different dimensions/columns.

Group Allcount OrderID – s parameter means siblings.
allcount(d-1, all(s), 0)

Allcount OrderID
allcount(d-1, all, 0)

Allcount costumer
allcount(d-1, all(l(1,0)), 0)

Best regards

Páll, CTS
Users browsing this topic
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.