Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression like sum(x+y+z) on top of that how get top 0-2% 3-5% 6-10% values in straight table.
Thank you
Message was edited by Community Moderator for clarity
Not sure what you mean? Would you be able to provide a sample with your expected output?
When i select the invoice, i have the first option approve application for lunch ? i select yes, and i have the next error Failed to lunch
might be helpful..
Hi,
May be like this,
Straight Table->
Dimension- Product
Expression -
1) Sum(Aggr(Sum(Sales)/Sum(Total Sales),Product))
2) IF(Sum(Aggr(Sum(Sales)/Sum(Total Sales),Product))*100>=0 and Sum(Aggr(Sum(Sales)/Sum(Total Sales),Product))*100<=2,'1%-2%',
IF(Sum(Aggr(Sum(Sales)/Sum(Total Sales),Product))*100>=2 and Sum(Aggr(Sum(Sales)/Sum(Total Sales),Product))*100<=4,'2%-4%','>5'))
And in Dimension Limits you can keep largest 10 Values as per your requirement.
Hope this Helps,
PFA,
Hirish.v