Sorry something went wrong, the right answer by jain.nitin88 answer was delete.
Please find the attached modifed application where I have tried to generate two separate field named as "Customers Group" and "Product Group".
You could also use this expression in button and further work on.....
In-case of any difficulty let me know...
See the attached file for his nice solution.
Qwadrant Test (1).qvw 698.5 K
The only problem is that this shows the (in the case of the customers) the top 80 % of the customers.
I want the few customers that represent 80 % of the total of Sum(Sales). (not 20 as I said in the example)
So the customers that represent 80% of the Sales, which is different then 80% of the customers based on the ranking.
What I want is:
If my total sales is 100, I want to see the top customers that are responsable for x% (let say 80) of that sales.
When I use, in my dimension color :
=if(RangeSum(Above(Total Sum(Sales),0,RowNo(TOTAL))) > Sum(Total Sales)* '0,8' ,RGB(200,100,100),RGB(125,222,120))
I got exacly the right colors for the right customers
What I want as a dimension is something like:
=if(RangeSum(Above(Total Sum(Sales),0,RowNo(TOTAL))) > Sum(Total Sales)* '0,8' ,'GroupC1', 'GroupC2')
But that doesn't work.