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”: []
}
