Skip to Content
0
Jul 24, 2019 at 08:58 AM

Sales order count split based on Sales Group in BEx

104 Views

Hello All,

I am looking for a BEx report which displays the No of sales order from billing cube and split the count into two columns(Orders <10000 & Orders>10000) and also the Sales order value with the same split. Can we achieve this logic in BEx query designer? Please provide your valuable suggestions.

No of Orders% of Total OrdersOrder Value $ Orders < 10k Orders 10< 20k Orders < 10k Orders < 20k Orders < 10k Orders < 20k 

Regards,

MSK