Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to give an own-given name to certain data which meets the conditions?
e.g.
Country, Customer, qty Customer Orders
Netherlands, A, 5
Netherlands, B, 7
Netherlands, C, 8
Belgium, N, 8
Belgium, O, 5
Belgium, P, 6
Germany, Q, 7
Germany, R, 7
Germany, S, 9
Condition is:
- if there are customers who have 8 or more than 8 customer orders, then I want to give that customer the name HEAVY (instead of their own customer name).
- Customers which have 6, more than 6, but less than 8 customer orders, should have the name MEDIUM (instead of their own customer name)..
- Customers whith less then 6 customer orders should have the name NORMAL (instead of their own customer name)..
Is this possible?
Kind regards,
ZR
Hi
I attached sample QV file using the pie chart.
Regards,
Iyyappan
Hi,
Did you checked by using this as dimension(Calculated dimension)?
if([qty Customer Orders] >=8, 'HEAVY',
if([qty Customer Orders] >=6, 'MEDIUM', 'NORMAL'))
Celambarasan