How to customize the total of the columns?

[elyashivg]

Hi
How do I customize the total of columns.
For example, I want the total of the columns to be always “5” even though the sum of all the columns is differnt than 5.
(Rows values: 5,3,2,5,2 => current total=17, but I want it to be: total=5)
Different example: I want to sum up the columns in a weighted average. (column1 value * 20 + column2 value * 80, for example)

using:

[Issue].CurrentHierarchyMember.Name <> '$total_aggregate'

overrides only the ROW total and not the column total.

Thanks

[zane.baranovska]

Hi @elyashivg,

If you want to show a specific value on the report columns, define a new calculated measures in Measures and describe the logic (documentation here: Calculated measures). And to highlight the column, use conditional cell formatting (see the documentation for more details here: Conditional cell formatting).

For example, to see the exact value “5”, enter value 5 in the formula editor.
Or describe the logic as a formula if you want a weighted value based on other properties.

Here is an example to illustrate the idea.

In this report, columns represent story points grouped by issue priority. And for the weighted value is created a new calculated measure, “Weighted value for total”, that multiplies story points with 100 for High priority, multiplies with 40 for Medium priority, and adds story points as they are for Low priority.

([Measures].[Story Points created],
[Priority].[High]) * 100
+
([Measures].[Story Points created],
[Priority].[Medium]) * 40
+
([Measures].[Story Points created],
[Priority].[Low])

To see only one measure, Story Points created, spit by priorities use the option to drill into measure by another dimension. More details here: Create reports

Best,
Zane / support@eazyBI.com

[elyashivg]

Thanks @zane.baranovska it seems to work for me

[german.globalblue]

Hello everyone,

I have a reporting of Sprint issues committed, subdivided in Story, Support, Bug and Enabler, like this:
Sprint issues committed
Story / Support / Bug / Enabler

I want to add a column adding the total of Story + Support + Bug + Enabler
Sprint issues committed
Story / Support / Bug / Enabler / Total

But when I create an Specific calculated measure:

[Measures].[ Total de Issues commited] =
([Measures].[Sprint issues committed],[Issue Type].[Bug])+
([Measures].[Sprint issues committed],[Issue Type].[Enabler])+
([Measures].[Sprint issues committed],[Issue Type].[Story])+
([Measures].[Sprint issues committed],[Issue Type].[Support])

The result shows me instead, another column, but with all the subdivision again.

I dont want to use the Total alternative, because, I want to do the same, not just for Sprint issues committed, but also for Sprint issues added, and Sprint issues removed, and I can not use the total for each of them in the same reporting.

Somebody knows, what I am doing wrong?