This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thank you for your time and help in advance
my data is
What Ia m trying to do is
In an automated way as there will be a column added every month and I hope the workflow can pick it up without hard-coding in formula icon
Hi @Sherif1 ,
Multi row , transpose , cross tab and dynamic rename can get expected results.
If you are looking for sum in values change the values to numeric and formula in multi row .
Attached a potential solution to your challenge.. I hope it helps and gives you an idea on how to approach it.
I basically Transposed your data so that you keep looking at your columns dynamically
Used 3 multi-row formulas, one is to create the labels, one is to generate the number you're looking for and one is to keep the order you already have
then used a cross-tab to have your data in different columns as you had before... added a dynamic rename just to rename columns.
This workflow should work fine as you add new rows and columns to your data
Hope this helps.