cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying data in a chart

Former Member
0 Kudos

Hi experts,

I m using BW queries to display data in a chart.

The scenario which i have is :

i have diff values for porfit and loss for diff periods.

For example:

Indicator for Asset/Liability     Value      Year/Period
D                                          200         Jan 2007
D                                          300         Jan 2007
D                                          200         March 2007
C                                          200         Jan 2007
C                                          200         Jan 2007
C                                          300         March 2007

Now my scenario is that ... i need to addup all the debits(D) and credits(C) for diff periods (Jan 2007 , March 2007) and display it in a chart over all periods.

I have used a query which wil return me all the values from the backend.

Then used 2 filters to get seperate data for D and C and then used a union operator to combine the result of 2 filters.

Now the prob is that my filters are returning me correct values but when i use union operator i m getting only Jan 2007 values .. March 2007 values are not getting displayed.

How can i get the total values for diff periods so as to display it in a chart??

Can any one help me out in solving this ????

Ur suggestions will be rewarded.

Thanks,

Pratima.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member185086
Active Contributor
0 Kudos

Hi

As i understood your question .Do the following works around

1. In chart make one additional data series of each period and apply formula for

getting total of each different period .

2. If u want to display all period together then set axis to their id which differenciate each one .

Let me know if it works

[Points are welcome]

Best Regards

````Satish````