I need a beast mode that provides 2025 Sales % VS 2025 targets
2025 targets are based on 2024 sales up to todays date multiplied by a growth rate. For product category 1 the growth rate is 5.5% and for product category 2 it is 14.5%. Sales are recorded in the column 'Extended Amount' and date is determined by column 'TRX Date'. I currently have the below Beast mode but it is returning…
