BusinessObjects Board

How to hide duplicates but still sum the values of hidden duplicates?

Hi everyone,

This seems like a simple question, but I just couldn’t figure it out…

I’d like to remove duplications, but just keep one and sum the values of all the duplicate names. Example:

I’d like to turn left to right: avoid duplicate row aggregation and breaks don’t work however…

You should be able to do sum(value). Value does need to be a measure, so if it’s not create a variable setting it as a measure and sum the variable.

1 Like

dtolley is right, with an indicator variable it should work.

If you have access to edit the universe, put the value as measure, in the aggregation select SUM and also in the SELECT put the function SUM ()