Same KF in intervales. Calculating issue.

[former_member713182]

Hi:

I have report to show how many orders (counter and value) are between some intervales. for example:

below 1k, between 1k and 2k,....etc. It would be like:

Customer below 1k.............1k to 2k............2k to 10k....

ABC..............10 $1200.........22 $28100...........16 $32920

DHL..............12 $1800.........19 $21300...........12 $30100

It works fine only if I bring Sales Document to the rows (besides Customer). But I need it without Sales Doc. I need only the summary. What is happening is that Bex is doing the classification of intervals AFTER the aggregation.

How can I solve this on Query Designer 7.

Regards,

[former_member713182]

Did it with Exception Aggregation. Thanks.

[Former Member]

Hi Raj,

Create 3 (depend upon the no. or ranges) RKF on Value KF restrict them

with Customer using Value Range

For Ex

1, Value KF Restrict with Customer less than < 1k (Equal to)

2, Value KF Restrict with Customer in between 1K - 2K (in between)

3, Value KF Restrict with Customer in between 2K - 10K (in between)

and used this RKF is KF columns.

Hope this help, let us know if its work.

Thanks & Regards,