Sure Thomas i agree it depends on a model ... will get back with LBM test... But just an FYI, and am confused too .. whether its syntax or something else. EVALUATE('SUM (%1) OVER (PARTITION BY %2,%3)' , "Fact - SCM AP Spend Summary"."Converted Amount","GL Period"."Period Year", "SCM Vendor Mapping"."Revised Vendor Name" )…

Thanks for the Answer thomas. I agree this looks like an LBM So i need Converted Amt by Period and By Vendor and i can achieve this ... setting levels in RPD .. Now please suggest I have have more custom metrics and attribute columns which needs to use this Sum("Converted Amount) by Year , Vendor". So what makes more sense…