Top Values in Straight Table

[#1]

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

[sunny_talwar]

Not sure what you mean? Would you be able to provide a sample with your expected output?

[#3]

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 

[PradeepReddy]

might be helpful..

Recipe for a Pareto Analysis

[HirisH_V7]

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