Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have developed one report, based on select ranges..
Here not showing Total Contribution %, I have to show Contribution % and Based on top selection.. it should be change the %
If I am clear range, it should be top5 records.
PFA,
Thanks in Advance..
Try this expression:
Num(1 -
Sum(Aggr(If(Rank(If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),
If(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),
Sum(LineSalesAmount)))) <= $(vTop),
If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),
If(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),
Sum(LineSalesAmount)))), Category))/
Sum(Aggr(If(Rank(If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),
If(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),
Sum(LineSalesAmount)))) <= $(vTop),
If(vMin='--Select--' or vMax='--Select--', Sum(OrderSalesAmount),
If(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),
Sum(OrderSalesAmount)))), Category)), '#0.00%')
I am not sure I follow your requirement. Can you elaborate?
Try this expression:
Num(1 -
Sum(Aggr(If(Rank(If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),
If(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),
Sum(LineSalesAmount)))) <= $(vTop),
If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),
If(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),
Sum(LineSalesAmount)))), Category))/
Sum(Aggr(If(Rank(If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),
If(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),
Sum(LineSalesAmount)))) <= $(vTop),
If(vMin='--Select--' or vMax='--Select--', Sum(OrderSalesAmount),
If(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),
Sum(OrderSalesAmount)))), Category)), '#0.00%')
Thank you so much...
Actually in my real data my dimension Calculated dimension
if i am use that dimension.
will it works???
Nope, try with both Product and Category without the if statement
UPDATE: If this doesn't work, then I propose calculating this if statement in the script and call it Dimension (maybe) and then use Dimension as your dimension and use that in the Aggr() function also
Thank you sunny..
It's really very helpful....