Row wise Sum after Multiplication.

[sarfaraz_sheikh]

Hello All,

I want to show the sum of rows after multiplication without aggregation . below is the example for clear level understanding.

I have below two columns [9LE Bulk] & [No of CR Pack On] which gets multiply and result will be your [Core Sold On premise] Column.

I am getting the expected result by using AGGR function but i do not want to use it as it is slowing down the performance while loading the chart at front end.  I cannot shift it to back end also because both  [9LE Bulk] & [No of CR Pack On] operating different dates columns on which user is making selection.

I want to do something in front end without aggregation and help would be much appreciated. 

[9LE Bulk] =

Count({<NumDateKey={">=$(=vFromDate9LEBulk)<=$(=vToDate)"},FLAG={2,3},

[Secondary Diff to Primary Flag]={0,1}>} Distinct [9LE Bulk])

[No of CR Pack On] =

Sum({<[BDE Visit Frequency]-={'000','NO CALL','VIRTUAL'},[Secondary Diff to Primary Flag]={0,1},

[Valid from]={"$(=vValidFrom)"},[Valid to]={"2958465"}>}[No of CR Bulk on])

[Core Sold On Premise]  = [9LE Bulk] * [No of CR Pack On]  -------------Without Aggregation

[Core Sold On Premise]  = Sum(Aggr([9LE Bulk] * [No of CR Pack On],Outlet,Product(IPL)))  -------------WithAggregation

Without Aggregation:

With Aggregation:

QVW is also attached here for your reference based on sample data not on real time data.

Thanks

Sarfaraz

[sarfaraz_sheikh]

For performance Optimization .....Its taking long time for processing while reloading chart as i have 10+ crores of records.

Thankk