Calculate percentages of the current vs previous, but the date is not fixed

[Anonymous]

Hi Profs,

I have a question related to this, in example 4_27, 5_25, 6_22 will not be fixed, meaning the date will change. Now there is problem that how to calculate the percentage with the dynamic date....

https://1drv.ms/x/s!Am9VKMj_rOZJoHX29cZH2kpjmqAD?e=zq76F4

Thanks in advance Profs

[sturlaws]

Hi @Anonymous 

Adding data to a post is always a good thing, so kudos for that. But it is not at all clear what you are trying to achieve. Descriptions of what the columns contains would also be usefull.

Cheers,
Sturla

[Anonymous]

Hi Prof,

the description is here

for the quantity I want to compare based on the date, and the date will change, not fixed, next month will auto add the new date with the relevant values, and the 4_27 will not exist. For this part, I have already done, just that for the percentage change, need to compare the Qty such that how many percentage increase or decrease using the date col for each category like BG, Divsion Name etc.

@sturlaws