Create sub-totals per member of dimension

Questions & Answers
1

I’m trying to achieve something similar as asked in this post: Percentage of (sub)total, and saw there’s no answer to that.

I have the dimension of “logged by” which contains as members each user that has logged time (it is the first column), and then, the logged time per issue as measure, called “hours per areas” (last column), but when I try to add the calculated % of total, it shows the percentage including all the rows, as “TotalRowsSet()” is used.

I would like to know how to get the total of logged hours per member (user) of dimension “Logged by”. I’ve tried the following hoping it would restrict the set to only the current hierarchy member, which is an individual user, but I get the same as the measure “hours per areas”:

Sum(
  {[Logged by].CurrentHierarchyMember},
  [Measures].[Hours per areas]
))

My expected result is as following (in blue), so, once having the total sum per member of “logged by”, I will be able to get the %.

image
image1227×344 12.7 KB

I’ve search for the existing documentation but didn’t find how to achieve it on my own.

Btw, I’m kind of new to EazyBI.

Thanks all in advance

2

The EazyBI support gave the solution to this:

([Measures].[Hours per areas]
/
DefaultContext(
([Measures].[Hours per areas],
[Time].CurrentHierarchyMember,
[Logged by].CurrentHierarchyMember
)
))*100

image

Thanks to the team!

2 Likes