Hats Off for your Explanation sir, All your vides are good. Sir I have little doubt this WINDOW_MIN( IF not ISNULL(SUM([Sales])) then INDEX() END)-INDEX() this gives first row value always if am not wrong but as percentage difference formula i.e. (current value - previous value)/previous value*100 .at" Appliances " level we have 42,168,180 values here it is not taking as taught formula (180-168)/168*100 .it is behaving to take first row value i.e.(180-42)/42*100 this is not correct as formula if my understanding is wrong please correct me.
Hats Off for your Explanation sir, All your vides are good. Sir I have little doubt this WINDOW_MIN( IF not ISNULL(SUM([Sales])) then INDEX() END)-INDEX() this gives
first row value always if am not wrong but as percentage difference formula i.e. (current value - previous value)/previous value*100 .at" Appliances " level we have 42,168,180 values here it is not taking as taught formula (180-168)/168*100 .it is behaving to take first row value i.e.(180-42)/42*100 this is not correct as formula if my understanding is wrong please correct me.
can u please provide the link of 2022 dataset
Hi, please use this link to download data visionforanalytics.com/resources/