Skip to Content
0
Oct 03, 2016 at 01:01 PM

Web Intelligence 4.0 Report Distribution formula problem

16 Views

Hello all,


I’ve a problem with a formula during creation a Weighted Distribution Report.


COLUMS SUMMARY


Product = Product sold


Net Sales = Sales of Product Sold


Net Sales (TOT) Customer = Total Sales of Customer that buy Product in row (all product that customer buy)


Net Sales (GLOBAL) = Totale Global Sales


WD = (Net Sales (TOT) Customer / Net Sales (GLOBAL)) * 100

Would be possible to create a formula that:


for the product specified in the first column, indicating the total sales of the customers who buy it not only for the product in row but all product that customer buy.


I tried it with a for each, in, for all operators, but I could not get the desired result.

Any ideas are welcome, thank you in advance.

Attachments

img1.JPG (107.4 kB)