on 08-29-2008 1:37 PM
Dear experts,
How to create need report compare price in comparison in previous period (previous row).
Example.
Row. Date
Columns: price, % trend in prices (increase/reduction]
29.04.2003 182,00 EUR/T
24.06.2003 165,55 EUR/T 9,3-
25.07.2003 146,30 EUR/T 9,9-
01.09.2003 145,00 EUR/T 0,1
26.09.2003 145,00 EUR/T 1,8-
Thanks
Tom
Hi Srini,
thanks for answer, but there are not period(month), there are days in the report and those days does not as a day by day. I thing there is not possible to use offset -1.
Thanks Tom
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, is possible to create type of this report in Business Objects. Tom
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Experts, could you help me?. Thanks. Tom
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, does anybody know, how to do it?
Tom
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for quick replay.
Maybe is possible to do it as a cell definition. The query comes from IC 0PUR_C01. The KF price is created as a calculated KF. This price is price for purchase order. We need compare price from those orders sorting by day. It means how the price of pur.order is changing in percent value. The pur.order is joint with day, but we want to see it as a AVG price also per monthly period. If you need some of screen I can send it you by e-mail.
Thanks
Tom
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
it may be possible with Cell definition.But depends on Query design.pl let us know the design of your query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.