Hi,
How can we sum rows data to a new calculated member without using total.
Row: Time
Column: issue created,Issue type(bug 1, task 2, story 4 ,total 7)
Column: Issue resolved, issue type (bug , task ,story,total)
If I remove story then automatically total : 3
I used hardcode mdx script but I want dynamic
Welcome to eazyBI Community!
To achieve a dynamic total that automatically adjusts when you filter or remove certain issue types, you should leverage the Issue Type calculated members.
For example, here I am aggregating Stories and Tasks with the formula below:
Aggregate(
{
[Issue Type].[Story],
[Issue Type].[Task]
}
)
When I create a table, I can then select this calculated member, and it will show the total of the created issues based on the Issue types you aggregated.
If you are new to eazyBI, I recommend checking out our learning center - Learning Center which helps to learn eazyBI and eazyBI interface in an interactive way. There is also a lesson about calculated members.
If this is not what you are trying to achieve, please share a screenshot of your report and let me know how you would expect it to look? If you are not comfortable sharing the screenshot in here, please reach out to us directly at support@eazybi.com and refer to this Community Post.
Best,
Elita from support@eazybi.com
