 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?
Thanks
|
|
|
|
|
|
 Rank: Advanced Member
Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 183
|
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 |
|
|
|
|
|
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.