Skip to Content
avatar image
Former Member

Displaying data in a chart

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 13, 2007 at 06:37 AM

    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````

    Add comment
    10|10000 characters needed characters exceeded