Price index

[MindaugasBacius]

Hello,

I would like to calculate the Price Index that depends products basket that was sold on chosen time interval.

Customer chooses the time interval that is used in following calculations:

The percents of Total appears:

Then according to the prices the Index is calculated:

I do only need the Total price index row. Every calculation should be made in front end.

I have attached the Example and the dummy data sample.

Thank you!

[sunny_talwar]

Sounds like a plan

[MindaugasBacius]

The test results are the same.

Thank you again!

[sunny_talwar]

Super