Hi,
I was working with a new analysis and reached a blocker when trying to implement a logic based on my requirement. Let me share with an example:
date Sale
19.06.2023 20,000
20.06.2023 34,000
21.06.2023 25,000
I need a field say. percent_sales = 22% *20000+ 72%*34000+6%*25000
Any guidance is appreciated!