Skip to Content
0
Former Member
May 12, 2008 at 01:24 PM

how to display every month and the last month quantity?

45 Views

hi, expert:

In infocube, there are two infoobjects 0calmonth, 0employee and one keyfigure zsaleqty, I want to display data resutl like this:

2007.01 2007.02 2007.03 .......

last_month_qty this_month_qty last_month_qty this_month_qty last_qty this nonth_qty ......

sales_manager1 100 150 150 120 120 210 ......

sales_manager2 80 100 100 110 110 90 ......

The question is, I don't want to change my infocube, for example, add a keyfigrue and in the transformation calculate the last month quantity; or add a virtual keyfigure. Did it have other way to display the result by using common query design skill?

Thanks.

Edited by: zhu zhu on May 12, 2008 3:26 PM