@Kitajima
追加情報ありがとうございます。
以下の方法でどうでしょうか?
入力データ
店舗ID,売上年,売上月,売上金額,売上日時,予想売上金額,固定費
A,2025,4,64286,2025/04/01,250000,500000
B,2025,4,120287,2025/04/02,250000,500000
B,2025,4,69854,2025/04/02,250000,500000
A,2025,4,83311,2025/04/03,250000,500000
B,2025,4,90112,2025/04/03,250000,500000
A,2025,4,89473,2025/04/04,250000,500000
B,2025,4,110977,2025/04/04,250000,500000
A,2025,4,136211,2025/04/05,250000,500000
B,2025,4,135025,2025/04/05,250000,500000
A,2025,4,63112,2025/04/06,250000,500000
B,2025,4,115071,2025/04/06,250000,500000
A,2025,4,115017,2025/04/07,250000,500000
B,2025,4,124902,2025/04/07,250000,500000
A,2025,4,91899,2025/04/08,250000,500000
B,2025,4,67455,2025/04/08,250000,500000
A,2025,4,133568,2025/04/09,250000,500000
B,2025,4,85976,2025/04/09,250000,500000
A,2025,4,59238,2025/04/10,250000,500000
B,2025,4,71060,2025/04/10,250000,500000
A,2025,4,57260,2025/04/11,250000,500000
B,2025,4,50475,2025/04/11,250000,500000
A,2025,4,107372,2025/04/12,250000,500000
B,2025,4,149220,2025/04/12,250000,500000
A,2025,4,100664,2025/04/13,250000,500000
B,2025,4,80937,2025/04/13,250000,500000
A,2025,4,110194,2025/04/14,250000,500000
B,2025,4,52494,2025/04/14,250000,500000
A,2025,4,137447,2025/04/15,250000,500000
B,2025,4,131069,2025/04/15,250000,500000
A,2025,4,120852,2025/04/16,250000,500000
B,2025,4,74691,2025/04/16,250000,500000
A,2025,4,100839,2025/04/17,250000,500000
B,2025,4,137350,2025/04/17,250000,500000
A,2025,4,114105,2025/04/18,250000,500000
B,2025,4,140614,2025/04/18,250000,500000
A,2025,4,146470,2025/04/19,250000,500000
B,2025,4,98442,2025/04/19,250000,500000
A,2025,4,97355,2025/04/20,250000,500000
B,2025,4,51582,2025/04/20,250000,500000
A,2025,4,50424,2025/04/21,250000,500000
B,2025,4,113615,2025/04/21,250000,500000
A,2025,4,115711,2025/04/22,250000,500000
B,2025,4,56806,2025/04/22,250000,500000
A,2025,4,115479,2025/04/23,250000,500000
B,2025,4,84132,2025/04/23,250000,500000
A,2025,4,133245,2025/04/24,250000,500000
B,2025,4,67583,2025/04/24,250000,500000
A,2025,4,134054,2025/04/25,250000,500000
B,2025,4,78489,2025/04/25,250000,500000
A,2025,4,52842,2025/04/26,250000,500000
B,2025,4,106598,2025/04/26,250000,500000
A,2025,4,89589,2025/04/27,250000,500000
B,2025,4,116349,2025/04/27,250000,500000
A,2025,4,72131,2025/04/28,250000,500000
B,2025,4,132449,2025/04/28,250000,500000
A,2025,4,52188,2025/04/29,250000,500000
B,2025,4,60113,2025/04/29,250000,500000
A,2025,4,138259,2025/04/30,250000,500000
計算フィールド
累積売上金額
runningSum(sum(売上金額), [extract("DD", 売上日時) ASC], [max(売上年), max(売上月)])
目標金額
max(extract("DD", 売上日時)) * 100000
時点進捗率
累積売上金額/目標金額
可視化結果
入力データと目標金額を適当に設定しているため進捗率が200%近くなっていますが、目的は達成できていると思います。