Key Figures Grouping

[Former Member]

Hi All,

I have this problem with a Query.

I need to develop a report that shows:

range amount N. Doc

-

---

-

---

-

---

0 - 5M 10.000 2

5M - 10M 90.000 9

10M - more 25.000 2

As you can see, I need to group by the "Amount" key figure value. How can I do that?

thanks for your help,

Mauricio

[former_member188975 · Accepted solution]

Hi Mauricio,

Could you please show how you want the report results to look like?

[Former Member]

HI,

this is What I want

RANGE AMOUNT N. Docs

0 - 5M 10.000 2

5M - 10M 90.000 9

10M - more 25.000 2

Range tells how much the individual amounts are.

Amount is the value I want to group for.

N.Docs is the quantity of docs which have the amount value in the range.

saludos (regards),

Mauricio

[Former Member]

Hi,

how do I create a Vitual characteristic??

Mauricio

[Former Member]

Hi Mauricio,

I think you would need a new characteristic to represent the range. You need to update that in the update rules or, if you want it to be flexible (the ranges may change) you need a virtual characteristic that gets populated during runtime of the query.

regards

Siggi