on 05-02-2007 1:05 PM
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.
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````
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.