8184461 发表于 2024-4-18 17:08:47

自由式表格同比,环比


在取数据源中汇总后,并在单元格过滤中,过滤出今年的数。
在下一行中,是否可以直接计算同比。cell19是今年的汇总,cell21是去年的汇总。
怎么样直接实现计算同比。
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfwAAACTCAYAAABrh6soAAAgAElEQVR4Ae1dCbNVxdX1T8Y4xDGOcR4+B9RonAcwiAYpIWLqUyr5nCBUQKIkItEAYjCKOA+EgmhEixiwLMuyv1onrvv23W93n3On9y6316269DndvXfvXr3OXn3OvfdxwqFDh5LewkAcEAfEAXFAHJhtDpxw7NixNA1vEG0a4lAM08EHrYPWQRwQB8SB0TlgtVWCPyUbHhF7dGILQ2EoDogD4kA/ByT4Enk9TREHxAFxQByogAMS/AoWWbvc/l2u8BAe4oA4UCMHJPgSfO3sxQFxQBwQByrggAS/gkWucSerOesOThwQB8SBfg5I8CX42tmLA+KAOCAOVMABCX4Fi6xdbv8uV3gID3FAHKiRAxJ8Cb529uKAOCAOiAMVcECCX8Ei17iT1Zx1BycOiAPiQD8HJPgSfO3sxQFxQBwQByrggAS/gkXWLrd/lys8hIc4IA7UyAEJvgRfO3txQBwQB8SBCjggwa9gkWvcyWrOuoMTB8QBcaCfAxJ8Cb529uKAOCAOiAMVcECCX8Eia5fbv8sVHsJDHBAHauSABF+Cr529OCAOiAPiQAUckOBXsMiD7GS//PLLdNvtt6cfnXhiWvnww1ObBEaNk/bTPMdB1m3Uvv/85z/TpZddNtZ1J8Y7d+6cx6NS26hzGYc98FiyZEl655135sVO/+vXrx/oGoGvs84+u8EY1xfs6UulnjgsBAck+BMUfCZRCCgSHBY0qluIhe46BpIQkhHeEADE22bL5E27YctBxHeYOP08IESI1QpS17l0xcaP6c8pAtYfcBgWQ29n/fqxec45Q4wuufTSzuteihOYfvzxx41owq8XTq5ftOZcl6iNMU+6ZOz22rVjRutm24mpX48IC2unYwn/JDkwk4JfSkT+ApzkLjsS96jOL/CRI0fSU089le64887eRsH3+eKLL9IT69alc887rxEHlBs2bEiw9X27ntskzISWS3jWJ5Nbl77Wjse075rgKQiIl3F2se3CCy+QXK9J8IS+u8ROrFjSdlQB8X547nHguFFJmwgjtll/XL/SvNkHZTTmQtTluEW+2jm1xYN5RGtFfHxesueDjNMWh9rr3lDMpODve/vtRghPO/30tOLBB9PqNWuy71d3755YQuHFbIUwquNF+NVXX6Xt27f3Hq1aO/ZBeeDAgXTV1Ven0884I6197LH04osvpuUPPJBOOvnkZp7wY/t3OabY2zGZdEuJGb6ZAK1tlzHZh/Zt46A/Y7LikkvM9M8S/ksxot0nV46Hkn7GUXLOfryuvrleFoeutuxH3HwM5Kivp50v2T8XC+6Wrc3rf/978ygcGNh6fxyth+8z6XPMadn99/c96SL2g3ACfUuCn+M+xuq6DpPGQv6P/83CTAr+0aNH0/oNG9KPTzop/e53v0s4XwyyMhFakYnqENvf/va3RsAR88233NIkB2vH+CHmDz70ULOhwcaG9Zjj1j/9Kf3ktNPSK6+80qtne6lkAouSDgUvaqNPilcUL/uUStqXxoA944wSLXEt+UAbYoQAIYn6vjj3yXVSCZe4RnMpYYU2CvWweFss6QPztILENcGdZluMxB4+GDtjtHequWPGQFuW9GH9sm1SJTiQi7OtvhQnMLT4Mn5i57nIdvj0nGSbyuNfgBd6DWdS8AEihPGBFSsaAXx5QAEc1yLwYrYJLarDeK+++mq69bbb0r59+xIWBRe5tWNM+/fvTxddfHFatWrVvI3M4cOH04033dRsCLrc5duk3paskOyieBAX/aCdYtqWHNmOecIGtrmkR/9tiY/9cnESQ8w1Sr62nfHlyhJe9JMru8YZ2dO2DYvIFnXkH+ZlhRxrAPw9Lpgn+ubWxvq0mFCs7RhRTPCbW69R5xqN11ZXiidnS0yj+ef4g3pgDXywljl84XPYtc7Fq/p6NwozK/ggNR994/E3jrsQHZ+Bb9q8OV12+eXNEwLcceMYQmztP/zww3Tfffc1GwpcvBdfckna9tJLfSLMRGATWlRn/eK41IeJ1CYXa4/Ecc2116Z//etfzabn0bVr05lnndWX3NGffhB7W1K2MXlBQBsTs52njantmPZR0kNsiDE338g3+kZxoi+xhU//Zvwle+I2SDw+xlF8YFzGzXi9/9w58IVthHPOBvVcH9hy3raO8bAE9lu2bOkJWsk3YinNo7QWJb/DtrXFE/klp4iN70OsIk7SNrcm8CnBr1egPZdGPZ9pwQc4O3bsaET5rrvuahJXCbCDBw82d8j4LPyee+9tPht/YevWdP8vf5lee+21nuDzOwJXXHll2rRpU0Kf2++4I518yinNRwn8CIEXs01oUZ2PqdQHG43zL7ggvMPHXf3y5ct7CQLnXvBt8uHdBRN1W4nE88677zb+7Zzo09b5OZXOaW+THjGw4tEWH9th89vf/rYRNx8TxvAJlGMxYVuRYWz0M4pYEwPrn3VdSo69du3aeWtQsqcd5wAMiFWXkutCnDx+0aaMY7ZtJuGbcUVzoB+uTdRnnHVt8URjEZdcjJyDBF/CHfFnIetmXvAhvs8++2xzt47P9SnGHuSuHwF89tln6drrrksPr1rV94142OMxO8QYogz/TAQ2oUV1PpZSHzyBuOeee+Z9hg8fu3btSmeceeY8QaN/+mUCZ/0wpRUtL4qD+qM942KCzCVQ+KeNxTYaFz6ZaBkzvoTFusgP+yEOtg8SWxSHrYMvL5q2PTq2a8djzB3HKBlfZDtsHXxiQ9Am2sAL/ex6cQ3bbDFGaQ0510nML8KlLZ7IhjHa+dt+xAecA/dsP9rm5oe+g3LFjq1jbTIsB2Ze8DFZ/IQNP3GDGL7xxhu9O3ULBBMU7ohzmwL0f+mll9JPzzln3u+K0YYv3p1y6qm9L83xYrYJLaqzceC4rQ+fMOALesuWLWu+mX/f0qWNiGGeC50gKIp2nrzrK91BUgxon0t6Hh+c08aOGfVjHTHlmEzCiI/iz75oYx3HYWzkiU3atOtS0l/XuOGTsdPGnuMYMWHNGXOXONr6cP3a5sn5cJ3JPeJEvHPjtQks50r8c37GVY9xOJdBywgrjw99sm/b/NCPmI5rjvJT7yagCsEHwXHXfcGFFzY/Z4s+z8dP2/B5fdvP9PAzOF60udJfzEzUiIMXuK3zF2CXPvY7BIgbTx3wc6dHHnmkU4JgQs7NIVcfiQqTmp0TBSNK+L6N9oMkddrYMT2OpXPGwHnaOLF+nCfHYWzEjWtcGiNqo7+ucUf9c/xATJgPY43G71LHOXbxY3HkRw2wow/iWypLWHCuXWLpMre2PhinFE9kzxgjThCH666/vscpjAE80J+2ufmhjwS/XoGO+DZKXTWCD5DwbX3cFePROx7BW+BwYTHJ23p/jAsTf+Tm+eefTy+//HL4nuQjfR+PPcfjfnyRsEvCYiKKkpT1aY9zGEWiRCGwQkpfvo32PukxxpJYlNpy64l5wI6xMekSNztPHxtjGgQ3zhsl/XEs2+aPGZdP+KyPfLAtN3c/RnSOuUW+o75YM/RFjLDDG9jiOxSIARjjzXgYH/GjPXCJ/LO/50bUd5J1mMMwMcAGcyce4A/ixPyBGb8Tk/PNfsBhkvOT7zo2FdUIPh7T4zN8/8U6En3jxo3N43g8lmddVOIOGo/033v//WI/2DJZ2eQZ1flxuvTxNjjHYuIXBXgKEbXbumGEC8mHidv6ikQMCdKKqu3v22ifS3rWlse0sdiyLVcS19w4mB/82eRMG7TB7zC4+Xgwvhdx34fjRvMrtdEPxgD+jJv1xB5tg75hSz8oiQW+kU/Bt+08hh15w9h9XOzrS/bPrZnvP8o5YiJnOS7jJCeiONA3+rv79AEbi4GN0fax9TzG+G1cYV+VdYj2KOtcjeDjW/a4u1+6bFnfl+0IHj9/f/LJJ/uSGttZ/vGPf2ySAj4CYF2u5MVsk3ZU5+279PE2OOdPofa+9VZrbEzWTGiRP1+Hvkzcti0SXwqLFwnY+TbaR8kU/Zkw28ZkO+L0vjBfJGVglBM6YmHnybVg2zC4MS6W1j/rbEl8/BzYhzFZXrHNlvRj1yCqszbRcc4G8SEG/u0FYuR9oJ6ixdhzfb3tOPD2PqNzxkVMeW7jJA5+XXCXDjtuFujfzhu20bXDcbzPyAfrVErYh+VAFYLf5ff4+GLfz2++uXlcv3fv3qxglr4L8Pnnn6etW7f2bHkxM4lgkaI6v3hd+ngbxIyPGvDHhvzHFb4vzodJpEhgUdKiYNt5MjnmxNUmR9pHSY9Y2P6InzZ2TNQjRvSlwPi5Iy7fRl9M7naenAfKYXGLYkCMHM+2d1kXYuLnbv3kjv18cv1sfWTDONHGeKL5EFvGWuprx+SxXQvWTaLkHDmHXJxox3cVMC9ggP9sCCViAn+xrii9PfxH1w77RdyHT4zn+TqJ+ctnHZuImRd8fK6Nu3rc3eM3+SVi48LFF/vQd8WKFeHv8PHRwO83bmz+bv05557b/Ac2+Pv3a3796+aCthcuL2YmO4wd1fmY2vrgacUdd9yRnnvuub6/o4+/soe/JUB/EH7/O3y2MWEzwbG+VKJvlLR8UocPJlCUJZ9oo73Fztqw3Yok6yy2HDPnh3H5BEpfERbwhXHt2Da2YY45no19ED9t/Cj5IkZd1oV+IhvMAY+5UTKeCD/asi3qC4wjLEbFifG3lYzJ8oJ1jDvywblZLNEfP73bvXt3U2IOsEWf6NrhODnOwp+NK4pDdXWI9TjWeaYFv+1z+whACOYjq1c3f9ceSR7if8svftH7bT1s4HfPnj1pyQ03NMKPfj+76KJG/PGkgH55MdtkFtWxP8u2PhBrfCsffyAIY+Ov/OF/ymNyoZ/FFHzG0KVkYs8lPfhAHyTSbdu2NfjShtjyvOQDfpB4fQKlrU/uNqGjbZyiT39WLLpghT5t/Cj5sXMq9bNtbTaMx+PHeos362zfnOAPsym1cXc95vxsTOQE+RX5Qtx2blEf1mGMkuCDW7l31zE4lkptAHIcmGnBx2/u8dv7Ln9lLwfQrNYzmeaSTK4+SlpdkmMJR4qAFWsKYi6OQeptIkfi9QmU8ft+GCOqs3GW5lVq45glQcnZE69hbClug+DHvrCNYmI8FivWwdbasZ59iYPHlPV+raLxJ1XXdo1E10IuFmAQ9Scefv70A5wWEwPGoXI2NhEzK/hdPrevmcRMZky8XbBA3yhpMTl3FSCOTSFBuVBJrSR4xALJ1wsV8WHsuQTNfl1K+uK4XWzQhyLRFW/rl/O3Imzbo+M2G8bDeRC/CEP2Zez0TVuOz/pB4qStLcFNjFl642M/azOJY8wjunaIR45PwGWhro1JzFs+p2ujMJOCj0fZ+K09Hscv1v+UJ6JPF9G5Hki8PoFyw4LPpCFEFCPa+JJJelQxgl/4gDDmEr4fexrPiQdFGxsZ/CIC9VG86Ic58+3XY5yY+LE4pi3HsY7RPFU3nTmg5nWZScHH7+3x1+fwDVp8Hr96zZrsG599L8QOv2aSae5KfOKAOCAOLD4HZlLwccdgd/Cl47a7OZF08UmqNdAaiAPigDgwOgdmUvBFjNGJIQyFoTggDogDs8UBCf6x2VpQXaBaT3FAHBAHxIGIAxJ8CX74xaqILKpTEhEHxAFx4PjlgARfgi/BFwfEAXFAHKiAAxL8ChZZO/Ljd0eutdPaiQPiwLg4IMGX4GtnLw6IA+KAOFABByT4FSzyuHaH8qM7DXFAHBAHjl8OSPAl+NrZiwPigDggDlTAAQl+BYusHfnxuyPX2mntxAFxYFwckOBL8LWzFwfEAXFAHKiAAxL8ChZ5XLtD+dGdhjggDogDxy8HJPgSfO3sxQFxQBwQByrgQJ/g42Sx33s+3J+W/uVNvYWBOCAOiAPigDgwZg5AY6HzJ6QpeO0+eFgLPOYF1gZKG0hxQBwQB8QBcAAai5cEX0KrzZY4IA6IA+LADHNgqgV/07sH0iv/+Kx5v7z/075jf2775drQx7fxHCWP2c+fdxkj8lOy4xiR3UK0LcQYnL/HtcucFzI+Gw+Phx2fc6Yfe26P6X8QbNi35GeSbRyfc1P539whHITDtHEAGmqf7kyV4P/jyNG+4HCulxAQAkJACAgBITA4AjlNnYpH+rngBp+mLISAEBACQkAI1I1ATlMl+HXzQrMXAkJACAiBGUNAgj9jC6rpCAEhIASEgBCIEJDgR6ioTggIASEgBITAjCEgwZ+xBdV0hIAQEAJCQAhECEjwI1RUJwSEgBAQAkJgxhCQ4M/Ygmo6QkAICAEhIAQiBCT4ESqqEwJCQAgIASEwYwhI8GdsQTUdISAEhIAQEAIRAhL8CBXVCQEhIASEgBCYMQQk+DO2oJqOEBACQkAICIEIAQl+hIrqhIAQEAJCQAjMGAIS/BlbUE1HCAgBISAEhECEgAQ/QkV1QkAICAEhIARmDAEJ/owt6Din880336Q777or/ejEE9Mjq1eP0/VYfY0aJ+2neY5jBazF2ZEjR9LlV1wx1nUnxq+//vq80Utt8zovQgXwuPHGG9Mnn3ySHX3Tpk0DXSPwdfZPf9pgjOsL9noJgUkjIMGfNMI/+GcShYAiweEV1S1QOJ2GQRJCMsIbAoB4215M3rQbthxEfIeJ088DQoRYrSB1nUtXbPyY/pwiYP0Bh2Ex9HbWrx+b55wzxOiyyy/vvO6lOIHpp59+2ogm/Hrh5PpFa851idoY86RLxm6vXTtmtG62nZj69YiwsHY6FgLjRmDmBb+UiPwFOMlddiTuUR0W+Msvv0yPrl2bzjn33CbZ/+S009L999+fDh061Lr+Bw4cSNdce22fcLUaBR1sEmZCyyU8a87k1qWvteMx7bsmeAoC4mWcXWy78MILJNdrEjyh7y6xEyuWtB1VQLwfnnscOG5U0ibCiG3WH9evNG/2QblYrxy3yFc7p7YYMY9orYiPz0v2fJBx2uJQe30IzLzgf/Txx+m8889Pp59xRlr58MNp7WOPZd9vvPnmxBjAi9kKYVT31Vdfpf+55pp07nnnpSfWrUu7du1K69ataxIE5oH5RK/PP/88rVmzJp108snz7lSj/qU6ir2NlUm3lJjhkwnQ2pbG8m20bxsHdozJiksuMftx4L8UI9p9cuV4KMf54pz9eF3H4HpZHLrash9x8zGQo76edr5k/1wsuFu2r3fefbd5FA4MSq9oPUr9J9GGOS1/4IG+J13EfhBOoG9J8HPcx1hd12ES85fP4x+BmRf877//Pm3avDn9+KST0jPPPJNwvhgvJkIrMlHdv//977Rly5b07bff9oX50UcfNUni4VWr0nfffddrQ6JcsWJFMz9sEm699daRBJ8JLEo6FLyojQFRvOw82dalpH1pDPhhnFGiJa4lH2hDjBAgJFHfF+c+uU4q4RLXaC5tmFGoh8XbYkkfmKcVJK4J7jTbYiT28MEXY7R3qrljxkBblvRh/bJtUiU4kIuzrb4UJzC0+DJ+Yue5yHb49Jxkm0oh0AWBmRd8gACB/NXKlQmPxne/9loXXMbehxezTWhRXW5gJN2777knXXf99ek///lPrxvqH3roofT7jRvT119/XRTCnlFwYJN6W7JCsrPzsO7oB+0U07bkyHYkM9jANpf06L8t8bFfLk7GjLlGyde2M75cWcKLfnJl1zgje9q2YRHZoo78w7yskGMNgL/HBfNE39zaWJ8WE4q1HSOKCX5z6zXqXKPx2upK8eRsiWk0/xx/UA+sgQ/WMocvfA671rl4VV8XAlUIPpb08OHDzaNyPC7HcZcX7rJf2Lo1XXHllc0dNJ4S4Bh32/aFz9bxGTs2FLh4L7n00rRj586+pwlMBDahRXXWrz3GpgXCfuVVVyU8Bci9mJR9coX9/z7+eDrr7LP7kjv8MCEjdm8XjcO4vSCgLxOznWfkI1dH+yjpITbEaJNpzg/r0TeKE+2cB3z6N+Mv2RO3QeJhXCxH8YFxGTfjpd+2EvjCNsK5ZMv1gS3nbesYD0tg/+c//7knaCXfiKU0j9JalPwO29YWT+SXnCI2vg+xijhJ29yawKcE3yOq80EQqEbwAcqePXsaUb733nt735TPgYUvzv385pubz8SXLluW/vrXv6aXtm9PKx58MO3du7dnxu8IXHX11emFF15o+tx1993p5FNOaT5K4EcIvJhtQovqeo7dAUQeX8bDxsI/7rddkRSQbL1wR4Jvkw/6I5kwUbeV6PvJ/v2NjZ0Tfdo6G1/bMe1t0iNOVjza4mM7bJ5++ulmXj4mjOETKMdiwkbJ5MzY6GcUsSYO1j/rupQc+/HHH5+3BiV72nEOwIBYdSm5LsTJ4xdtyjim56SPE74Zl2/DOf1wbaI+46xriycai7jkYuQcyCnrg7bE2LbhGD493r6PzoVACYGqBB/i+4c//KG5W8fn+hRjD1DXjwDwBbvrlyxJq9es6RNh2OMLdBdceGHvm/W8mG1Ci+p8LDhHnIgXm4idO3dGXXp1SApI3G3JlWPnkkvPYYcDjMkE5kWxg3lfF9ozLibIXAKFMW0stn1OfziBT8bJmPElLNZFftgPcbB9kNiiOGwdfA2axO3a8RhzxzFKxmfHGfUYPrvwCnihn10vrmEbJzFGaQ0510nML8KnLZ7IhjHa+dt+xAecA/dsP9rm5oe+g3LFjq1jIVCV4GO58Tk3Pgs/86yz0nvvvRcygAkKj8BzmwIYQnzx0zn09699+/alU049Nb32w3cGeDHbhBbVeT8Yf9errzZPJvALA2wmSi8mlLbkWvIxShtF0c4TsbTdPTJe2ueSXhQbbeyYUT/WEXeOScwQI8WffdHGOo7D2MgT9BnmRX9d48YYjJ029hzHiAmiwJiHicvbcP3a5sn5cK0pTsSJeHv/PG8TWM6V+NNuUiXG4VwGLSOsPD70yb5t80M/YjqpOcvvbCNQneBjOQ8ePJgu/NnPms/0o8/z8fgen9e3/Uzv8SeeaE0I/mJmokYcvMBtnaUbHt1v2LCh2Tg89pvf9D1FsP3sMcZDImlLrtaGCZkJqGsZiQqTmp0TBSOKybfRfpCkThs7pp1f2zFj4LxtnMCT8+Q4jI24cY3bxvHt9Nc17qh/jkPkAWP1Y3c95xy7+LE48qMG2NEH8S2VJSw41y6xdJ1fqR/GKcUT2TLGiBPEYckNN/Q4hTGAB/rTNjc/9JHgR6irrisCVQo+wMG39fElOzx693fNuLCY5EtA4sLEb+O3bduWdu/eHb75x3J4MdsEEtVxPLThSQTiwG/xS08aaIMSsSOBWNGy7dExExFsu75yGEWiRCGIYvJttPdJjzGWxKLUlltPj5dfEztPHxtjGgQ3iy/9WU7YdnvMuHzCZ33kg225uVv/uWPMLfId9ceaoS9ihB3eWBN8hwIxYK3xZjyMj/jRHrhEL/b33Ij6TrIOcxgmBthg7sQD/MEL8wdm/E5Mzjf7AQe9hMAwCFQp+PYz8eizfPwOHo/j8Vi+9Hr00UebR/r/OHCg1K1pY7KyyTOqQ2f+ogBfGoyeQJQGY5JFUur6Gka4MA4Ttx0nEjHEktuE+Dba55KeHYvHtLHYsi1XEvvcOJgf/NnkTBu04TUMbj4ejO9F3PfhuNH8Sm30gzGAP+NmPbEvbZRybZ5fxALfyKfgcxxbwo68Yew+LtvfHrN/bs1s31GPERM5y3EZJzkRxYG+0d/dpw/YWAxsnLaPrecxxm/jCvuqFAIRAlUK/ltvvdXc3f9y+fLwMTk/f1+/fn2EWa/uxRdfbJICPgJoe/Fitkk7qoN44VcEd999dzp69Gib23ntNlHNa8xUMFkzoWW69VWjLxO3bYjEl8LiRQJ2vo32UTJFfybMtjHZjji9L8wXSRnilBM0YmHnyfVi2zC4MS6W1j/rbEl8/BzYhzFZXrHNlvRj1yCqszbRcc4G8SEG/u0FYuR9oJ6ixdhzfb3tOPD2PqNzxkVMeW7jJA5+XXCXDjtuFujfzhu20bXDcbzPyAfrVAqBQRCoTvB591z6PT6+2PeLW29tHtd/8MEHWTxL3wWAWG/fvr1ny4uZSQQNUR02G2eceWbfT/96TjocILH4ZNNmNkwixThR0qJg23kyOebE1cZL+yjpES/bH3OjjR0T9cSCAuNxQFy+jb5gSx+cJ+eBEq9hcGsMzT/0yfFMUyf/xMTP3frJHXNszifXz9ZHNsQBbYwnmg+xZaylvnZMHsMn14J1kyg5R84hFyfa8V0FzAsY4D8bQokX+AueovT28B/Ng/0i7sMnxvN8ncT85XN2EahK8PElONzV47N7/Ca/9MKFiy/2oe/KlSvD3+Hjo4HntmxpfquPP2v7f08+2Xzeji/Y4YK2Fy4vZiY7jB3V4aLGxwkPrFgx1N/8h70XRIyF7ym0/eEd2HZ9oW+UtHxShz8mUJRtL9pb7KwN2zFHxss6iy3HzPlhXD6B0hd927HhC+PasW37MMccz8Y+iJ+IQ13tiVGXdaHPyAZzwGNulIwnwo+2bIv6AuMIi1FxYvxtJWOyvGAd4458cG4WS/THT+/wdztQYg54oU907XCcHGfhz8YVxaE6IVBCoBrBb/vcPgKJ/2sd7riR5CH+t91+e++39bCB37fffjvdeNNNvf+45qKLL27EH08K+OLFbJNZVIeLmqKSK0uJh/Y28SCGxRR8YtClZGLPJT34QB8k0B07djQuaUNseV7yAUNg5BMobT3G6Iv1QEmMfZ8u84v60J9fs6ivr4s45Pvkzu2ccn18fZsN4/HYsN7izTrbNyf4fIpg+/rYxnHO+dlxyAnyKxoHcdu5RX1YhzFKgp+77lHfdQyOpVIIWASqEXz85h6/ve/yV/YsQDUcM5mWEk3UFiWtLsmxhClFwIo1km80/jB1NpEj8foEyvh9P4wV1dk4S/MqtXHMkqDk7InXMLYUt2FwhG30YjwWK9ZhHGvHevYlDh5T1vu1isafVF3bNRJdC7lYgEHUn3j4+dMPcFpMDBiHyuMXgY+G6PgAAAUlSURBVCoEv8vn9sfvEo4eOZMZE28Xj+gbJS0m564CxLGt6CxUUisJHrFA8vVCRXwYey5Bs1+Xkr44bhcb9KFIdMXb+uX8rQjb9ui4zYbxcB7EL8KQfRk7fdOW47N+kDhpa0twE2OW3qU/W219jXKMeUTXDvHI8Qm4LNS1Mcr8ZDu9CMy84ONRNn5rj8fxi/U/5U3v8tcdGRKvT6DcsOAzaQgRxSiHFJP0qGIE//ABYcwl/FwM01RPPCja2MjgFxGoj17oV9rsjRMTP5Ydl8fjWMdonqoTAtOAwMwLPn5nj7+ah2/QPrp2bfaLcPiztZs3bw5/pjcNC6UYhIAQEAJCQAiMgsDMCz7u4Lh7byvb7uZGAVq2QkAICAEhIAQWE4GZF/zFBFdjCwEhIASEgBCYFgQk+NOyEopDCAgBISAEhMAEEZDgTxBcuRYCQkAICAEhMC0ISPCnZSUUhxAQAkJACAiBCSIgwZ8guHItBISAEBACQmBaEJDgT8tKKA4hIASEgBAQAhNEQII/QXDlWggIASEgBITAtCAgwZ+WlVAcQkAICAEhIAQmiIAEf4LgyrUQEAJCQAgIgWlBYKoFf/fBw2npX97svXGOgPUWBuKAOCAOiAPiwGAciDQVm5ETpmFH4oOz4q/juY2QsBAW4oA4IA6IA4NyABorwTdPFQYFUP110YkD4oA4IA5MLwfeSEv/8t93T/APHTqUFvu958P9vcf50wueiK21EQfEAXFAHDj+OACNhc6fcOzYsbTY7/c/+yIhIJR6CwNxQBwQB8QBcWA8HKC2QuenQvARCHYfi73x0PiLv/nTGmgNxAFxQBwYHwestkrwp+AJh8g9PnILS2EpDogD4sAcByT4Enk9TREHxAFxQByogAMS/AoWWTvcuR2usBAW4oA4UCsHJPgSfO3sxQFxQBwQByrggAS/gkWudTereetOThwQB8SBOQ5I8CX42tmLA+KAOCAOVMABCX4Fi6wd7twOV1gIC3FAHKiVAxJ8Cb529uKAOCAOiAMVcECCX8Ei17qb1bx1JycOiAPiwBwHJPgSfO3sxQFxQBwQByrggAS/gkXWDnduhysshIU4IA7UygEJvgRfO3txQBwQB8SBCjggwa9gkWvdzWreupMTB8QBcWCOAxJ8Cb529uKAOCAOiAMVcECCX8Eia4c7t8MVFsJCHBAHauWABF+Cr529OCAOiAPiQAUckOBXsMi17mY1b93JiQPigDgwxwEJvgRfO3txQBwQB8SBCjggwa9gkbXDndvhCgthIQ6IA7VyQIIvwdfOXhwQB8QBcaACDkjwK1jkWnezmrfu5MQBcUAcmOOABF+Cr529OCAOiAPiQAUckOBXsMja4c7tcIWFsBAHxIFaOSDBl+BrZy8OiAPigDhQAQck+BUscq27Wc1bd3LigDggDsxxQIIvwdfOXhwQB8QBcaACDkjwK1hk7XDndrjCQliIA+JArRyQ4EvwtbMXB8QBcUAcqIADEvwKFrnW3azmrTs5cUAcEAfmOCDBl+BrZy8OiAPigDhQAQck+BUssna4cztcYSEsxAFxoFYOSPAl+NrZiwPigDggDlTAAQl+BYtc625W89adnDggDogDcxyQ4EvwtbMXB8QBcUAcqIADEvwKFlk73LkdrrAQFuKAOFArByT4Enzt7MUBcUAcEAcq4IAEv4JFrnU3q3nrTk4cEAfEgTkOSPAl+NrZiwPigDggDlTAAQl+BYusHe7cDldYCAtxQByolQNW8P8fpPMsZ2Uokt0AAAAASUVORK5CYII=

美滋滋 发表于 2024-4-18 17:08:48

如果是固定行的话,可以把第二行依旧取去年的值,然后把第二行高度调整成0,相当于是隐藏掉

yhdata_lyaa 发表于 2024-4-18 17:52:07

使用格间计算 (今年-去年)/去年的格子,
https://www.yonghongtech.com/real-help/Z-Suite/10.2/ch/make_visual_dashboard_complexform_free.html?zoom_highlightsub=%E6%A0%BC%E9%97%B4%E8%AE%A1%E7%AE%97

8184461 发表于 2024-4-19 07:59:40

yhdata_lyaa 发表于 2024-4-18 17:52
使用格间计算 (今年-去年)/去年的格子,
https://www.yonghongtech.com/real-help/Z-Suite/10.2/ch/make_vi ...

这是在前面已经有今年和去年的值之后,在第三个格子进行计算吧。 如何第一个格子取今年的值,第二个格子取完去年的值后,直接进行格间计算。

美滋滋 发表于 2024-4-19 09:08:24

还有一个方法,修改你的数据集抽取项目,直接抽取当年度和前一年度的数据。同时环比数据也可以直接做出来了。

8184461 发表于 2024-4-19 09:26:01

美滋滋 发表于 2024-4-19 09:08
还有一个方法,修改你的数据集抽取项目,直接抽取当年度和前一年度的数据。同时环比数据也可以直接做出来了 ...

嗯嗯。我只是举一个例子。 我的需求其实是每个月的对比。

美滋滋 发表于 2024-4-19 10:04:36

每个月的对比,也可以通过SQL直接抽取出当月,前月以及做好环比数据。道理是相通的。
页: [1]
查看完整版本: 自由式表格同比,环比