Skip to Content
avatar image
Former Member

Design Studio cumulative sum filtered by a dimension (.UNX source)


I have a requirement of displaying a cumulative sum in a chart along with a dimension. My source is a UNX universe pointing at an oracle database.

I have managed to do so as explained in another post.

So my initial query result would be something like: (dim, measure)

"Days to complete" "number of projects"

7 3
10 4
11 7
12 12
13 26
14 49
15 50

My problem is that I also need the chart to be filtered by another dimension (department, for example), but to do that I need to add the dimensions to my data source, which make my cumulative sum wrong.

Ideally, I would like to add a filter to the data source without having to include an additional dimension in the selection area of my query.

Can you think of a solution for this problem?

I am using version 16.3.1

Many thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers