Re: sum values based on picklist item

Post Reply
ynkiss
Posts: 1
Joined: Fri Nov 25, 2016 1:34 am
OLAP Product: Cognos
Version: 10.2
Excel Version: 2016

Re: sum values based on picklist item

Post by ynkiss » Fri Nov 25, 2016 1:47 am

Hi All,

let's say a dimension has two elements;

first element-picklist (3 items) string and second element display a numeric based on selected item from first element.
and another dimension has 5 elements, means 5 x 2 (above elements).

I would like to sum numeric element value by 3 items into other cube.

Any rule that support aggregate value based on picklist item?

Post Reply