Totals in line charts
Hi All,
I have two questions and the version on OBIEE i am using is 11g
1.) How can we prepare a chart which has got a total line which contains a total value for all the measure
Eg:-- I have percentage, time and Sales% as measure. I want lines customer wise and also a single line which is total All. If its a pivot we can use totals at customer, can we use anything similar to that.
2.) In addition to above i want to show a cost line which is not customer depent, Its single value which varies with time. I want to show this in this graph as cost line.
How can we achieve this ?