# Total Issues and Tory Point across multiple Columns

**URL:** <https://community.eazybi.com/t/total-issues-and-tory-point-across-multiple-columns/388>\
**Category:** Questions & Answers\
**Tags:** jira\
**Created:** [March 13, 2018, 6:29pm UTC](https://community.eazybi.com/t/total-issues-and-tory-point-across-multiple-columns/388 "2018-03-13T18:29:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![briantaylor](https://community.eazybi.com/letter_avatar_proxy/v4/letter/b/ce7236/32.png) [@briantaylor](https://community.eazybi.com/u/briantaylor)\
**Post date:** [March 13, 2018, 6:29pm UTC](https://community.eazybi.com/t/total-issues-and-tory-point-across-multiple-columns/388/1 "2018-03-13T18:29:18Z")

</div>

I have a chart that has the Column of that has a measure for Total Story Points and Total Issues Resolved broken down by a custom field called Category - I want to be able to have a column that shows the total Row for all Story Points and Total Issues

{  
“cube\_name”: “Stories”,  
“cube\_reports”: [ {  
“name”: “Consumer Experience Resolved Issues”,  
“folder\_name”: “Custom”,  
“result\_view”: “table”,  
“definition”: {“columns”:{“dimensions”:[{“name”:“Category”,“selected\_set”:["[Category].[Project]","[Category].[Enhancements]","[Category].[Maintenance and Support]"],“members”:[],“bookmarked\_members”:[{“depth”:1,“name”:“Project”,“full\_name”:"[Category].[Project]"},{“depth”:1,“name”:“Enhancements”,“full\_name”:"[Category].[Enhancements]"},{“depth”:1,“name”:“Maintenance and Support”,“full\_name”:"[Category].[Maintenance and Support]"}]},{“name”:“Measures”,“selected\_set”:["[Measures].[Issues resolved]","[Measures].[Story Points resolved]"],“members”:[]}]},“rows”:{“dimensions”:[{“name”:“Time”,“selected\_set”:["[Time].[Month].Members"],“members”:[],“bookmarked\_members”:[]}]},“pages”:{“dimensions”:[{“name”:“Issue Type”,“selected\_set”:["[Issue Type].[Story]"],“members”:[{“depth”:1,“name”:“Story”,“full\_name”:"[Issue Type].[Story]"}],“bookmarked\_members”:[{“depth”:1,“name”:“Story”,“full\_name”:"[Issue Type].[Story]"}],“current\_page\_members”:["[Issue Type].[Story]"]},{“name”:“Profields Division”,“selected\_set”:["[Profields Division].[Business Technology]"],“members”:[{“depth”:1,“name”:“Business Technology”,“full\_name”:"[Profields Division].[Business Technology]"}],“bookmarked\_members”:[{“depth”:1,“name”:“Business Technology”,“full\_name”:"[Profields Division].[Business Technology]"}],“current\_page\_members”:["[Profields Division].[Business Technology]"]},{“name”:“Project”,“selected\_set”:["[Project].[All Projects]"],“members”:[{“depth”:0,“name”:“All Projects”,“full\_name”:"[Project].[All Projects]",“drillable”:true,“type”:“all”}],“bookmarked\_members”:[],“current\_page\_members”:["[Project].[All Projects]"]},{“name”:“Profields Project Team”,“selected\_set”:["[Profields Project Team].[Project Teams]"],“members”:[{“depth”:0,“name”:“Project Teams”,“full\_name”:"[Profields Project Team].[Project Teams]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled\_into”:false,“id”:"[Profields Project Team].[Project Teams]"}],“bookmarked\_members”:[],“current\_page\_members”:["[Profields Project Team].[Project Teams]"]},{“name”:“Profields Owning Dev Manager”,“selected\_set”:["[Profields Owning Dev Manager].[Owning Dev Manager]"],“members”:[{“depth”:0,“name”:“Owning Dev Manager”,“full\_name”:"[Profields Owning Dev Manager].[Owning Dev Manager]",“drillable”:true,“type”:“all”}],“bookmarked\_members”:[],“current\_page\_members”:["[Profields Owning Dev Manager].[Owning Dev Manager]"]}]},“options”:{“nonempty”:true,“total”:“rows”},“view”:{“current”:“table”,“maximized”:false,“table”:{}}}  
} ],  
“calculated\_members”: []  
}

![Total%20Stories%20and%20Issues](https://community.eazybi.com/uploads/default/original/1X/57af140c573eb5c24216cd8effe3feb780594134.png)

---

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [March 16, 2018, 7:16am UTC](https://community.eazybi.com/t/total-issues-and-tory-point-across-multiple-columns/388/2 "2018-03-16T07:16:47Z")

</div>

To get the total in columns for both measures, you may use top hierarchy member of a dimension, like **All Categories** (see picture below with an example).

 ![eazyBI_Top_hierarchy_level_Total](https://community.eazybi.com/uploads/default/original/1X/78f7cafc9f11e1d1eea5c3af4b99bd13cb49ae7e.png)

If you would like to get total only for particular categories and not for all categories, then you may define a new [calculated member](https://docs.eazybi.com/display/EAZYBI/Calculated+Members#CalculatedMembers-Aggregatemembersinotherdimensions) in **Category** dimension and aggregate categories of interest. Use this calculated member in your report as total columns and expand it to get values for each category.

Best,  
Zane Baranovska / [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![briantaylor](https://community.eazybi.com/letter_avatar_proxy/v4/letter/b/ce7236/32.png) [@briantaylor](https://community.eazybi.com/u/briantaylor)\
**Post date:** [March 16, 2018, 4:08pm UTC](https://community.eazybi.com/t/total-issues-and-tory-point-across-multiple-columns/388/3 "2018-03-16T16:08:35Z")

</div>

that is what I was looking for - thank you
