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 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!

Cube View

2 Replies

  • 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.

     

  • fc's avatar
    fc
    Contributor
    3 days ago

    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