% of Top 20 Discount Value

[girish21595]

Hi All,

I have a requirement to show the top 10 discounts by Outlets with a field % contribution to the top 20 value.

Please find the attached excel for more info.

Thanks,

Girish.

[girish21595]

This is the expression used for the current month.

Sum({<$(vTargetCurrency), Month =, Year =, [Check Duration] = {">= $(vDurationSlider)"}, Date = {">=$(=Date(MonthStart(Max(Date),-1),'DD/MM/YYYY')) <=$(=Date(Addmonths(Max(Date),-1),'DD/MM/YYYY'))"}>}$(vDiscount_Value)*$(vSourceToTargetRate))*(-1)