Hi!
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 https://archive.sap.com/discussions/thread/3893008
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,
drserguey (BOB member since 2010-03-01)