I have the below data and i want to calculate below things
1- CoreRangeOn Premise = No of CR Pack On + No of CR Bulk On
2> Core Sold On premise = (No of CR Pack on * 9LE Pack on) + (no of CR Bulk on * 9LE Bulk)
However After doing the multiplication in second column i want to show the sum of record where i get one. like in below chart if you see there total 5 times 1 appears and i want to show the row level sum against particular outlet.
OR in short the logic is No of CR Pack on and 9LE Pack on is 1 then give 1 else 0 and then do the Sum of that 1's.
Note : Please advice the solution wihtout aggregation function as i have already done it and it is taking very long time to open chart in front end as i have very huge data. I want it to be done without Aggr function.
Is there anyway to do it in set analysis. All the above columns are calculated column and I am using Qliksense and help would be much appreciated.