Skip to main content
F
fc5
September 10, 2025
Question

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

  • September 10, 2025
  • 2 replies
  • 0 views

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 place a new column at the end of the cube view that sums the values of all the base entities. I tried to use the CVC function to sum columns, but it only sums the data of first base entity, ignoring all the other base entities.

Is there a way to achieve what I need, and if yes, could someone please help me? 

Thank you!

2 replies

R
RobbSalzmann
September 10, 2025

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.



 

F
fc5Author
September 11, 2025

Hi Robb,

thank you for your answer. You are right that I could just consider the GroupEntity in a separate column, the problem is that I'm looking to show the value of total eliminations for the whole group, and there seems to be a constraint between the E#GroupEntity and the C#Elimination members.

My idea was therefore to create a hidden column showing the Elimination values for all entities, and showing their sum in a separate col

Terms & ConditionsAccessibility statement