Hi

I am using Jedox for about a month and this is my first topic on this forum.

I would like to create a data function that selects all elements of a subset.

For example, I am taking the cube Biker from the demo of Jedox 7.

Does someone already have an idea about a possible solution?

Thanks

Lino

I am using Jedox for about a month and this is my first topic on this forum.

I would like to create a data function that selects all elements of a subset.

For example, I am taking the cube Biker from the demo of Jedox 7.

- I pasted a view by selecting the subset
**Elements on level 3**by the**Customers**dimension.

forum.jedox.com/index.php/Atta…0f01f2a6ba9f5cd39f69e5a36

- The view shows all third level elements of the
**Customers**dimension.

forum.jedox.com/index.php/Atta…0f01f2a6ba9f5cd39f69e5a36

- Now, I would like to create a data function in order to get the total
**Units**of the subset**Elements on level 3**of the**Customers**dimension.

My data function is:

The cell C5 contains the subset**Elements on level 3**of the**Customers**dimension. The subset formula is the following:

The result is that the cell contains only the**Units**value of the first subset element, while I would like to have the total**Units**of all subset elements.

forum.jedox.com/index.php/Atta…0f01f2a6ba9f5cd39f69e5a36

Does someone already have an idea about a possible solution?

Thanks

Lino

The post was edited 2 times, last by Lino83 ().