Monetary sales range

[cafcptg2011]

Hello,

I need to make a simple table with monetary sales range, but i'm stuck. I have a qvw with my problem to understand more quickly my pb.

Can anyone please help me?

Thanks in advance,

Cafc

[Sokkorn]

Hi Cafc,

Please check in my attached file.

Let me know if this one help you.

Regards,

Sokkorn

[cafcptg2011]

Hi Sokkorn,

yeah that's correct!!! thank you very much!

Cafc

[cafcptg2011]

hi

suppose now that i need to aggregate the sales for each customer in that monetary sales range. I have attached a qvw file to be more easy to understand what i mean.

thanks in advance,

cafc

[Sokkorn]

Hi Cafc,

Check my attached file to solve your problem. This one is not a good solution for you yet. If you have agood one besides my attached file, do let me know.

Regards,

Sokkorn

[cafcptg2011]

I adopted another solution... instead using a loading script (because, your solution doesn't work in my real data, i dont' know why.... 🙂 ) so, I created a calculated dimension to acomplished that, like:

if(aggr(Sum(sales),id_customer)<=500, '0 - 500',      

(if(aggr(Sum(sales),id_customer)>500 and aggr(Sum(sales),id_customer) < 750,     '500 - 750', ))

But with this, I can't sorted these ranges ... it gives me:

1000-1500

0-500

500-750, and so one....

i think I have to live with that... but if we have any suggestion.... 🙂

thank you for help.

regards

cafc

[Sokkorn · Accepted solution]

Hi Cafc,

It a good solution. For sort order you can check in my attached file.

Regards,

Sokkorn

[cafcptg2011]

Hi Sokkorn,

it's perfect! thank you very much...

regards,

cafc