Limitation - Query Designer

[Former Member]

Hi There,

I have scenario, whereby in Q.Designer in the column section I have a Characteristics called Fiscal year/period

I would like to a key Figure called Cumulative Balance, is this possible or simply is there a limitation ?

TQ

Kumar

[Former Member]

Hi,

Do you mean a running sum of your KF on Fiscal year/period values?

LauQ

[Former Member]

No, actually i's like this.

I want a report to look like this:-

AIC1000.200 Opening Balance K4/001.2004 K4/002.2004 .

AID1000.200

AITOT.200

..

..

..

..

so on

In this case, the key figure is cumulative balance which represents Opening Balance, and K4/001.2004 represents Characteristics - Fiscal year/period, which resides in column section. I can't drag n drop the key figure Cumulative balance to the column with fiscal year/period

TQ

Kumar

[Former Member]

Sorry nantha but I do not understand where is the limitation because it is always possible to combine characteristics and KF's in the column section. You might want to use structures for that purpose too.

Best regards.

LauQ