Forum Discussion

fc's avatar
fc
Contributor
4 days ago

Cube View sum of columns sums only values from column with first child

Hi everyone, I'm having an issue with a cube view. I have a column whose parameter is E#GroupEntity.Base. When launched, it shows one base entity per column, with its respective data. I need to pla...
Cube View
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
3 days ago

No need to calculate columns.  The total is already in your cube. 

Add a second column after your E#GroupEntity.Base column called GroupEntity Total.
Use member filter E#GroupEntity.Name(GroupEntity Total)
The .Name(GroupEntity Total) part puts "GroupEntity Total" as the column header for your total.  You can change that to anything you want.