love it sir 😁 but you need the trial balance data first, is there any tutorial that cover process of journaling from bank statement to get this "trial balance each month" automate ? or you just do journaling yourself, and present the report with this?
Amazing work, thank you so much sir. Please I have a question, my excel does not have the Sequence function, please what other alternative do I use in spilling the months
CUBERANKEDMEMBER("ThisWorkbookDataModel",$B46,COLUMN()-2) and drag right. COLUMN will return the COLUMN number you are in. In this case I am in Column C that is why I have -2 to give me 1 and so on.
Why when i change the numbers in my original trail balance, the data doesn't change in my pivot or dashboard? Even if i deleted all data in trail balance still see numbers in pivot and dashboard? Is there mistake i made and in which part?
@FinexSkillsHub I should do (load to) from the queries and connections each time I changed the numbers or add numbers. So if it's the only way then thanks your video is amazing actually and I learned a lot of it💯, And if there is another way faster, it will make the video perfect!
Great thanks too much
love it sir 😁 but you need the trial balance data first, is there any tutorial that cover process of journaling from bank statement to get this "trial balance each month" automate ? or you just do journaling yourself, and present the report with this?
Fantastic presentation.
amazing- Wonderful work sir
Amazing work, thank you so much sir. Please I have a question, my excel does not have the Sequence function, please what other alternative do I use in spilling the months
CUBERANKEDMEMBER("ThisWorkbookDataModel",$B46,COLUMN()-2) and drag right. COLUMN will return the COLUMN number you are in. In this case I am in Column C that is why I have -2 to give me 1 and so on.
Have you made any 3 statement ( Income , BS & Cash flow) with Dynamic Arrays ?
Yes. Coming soon here
@@FinexSkillsHub Great! can't wait to see
Why when i change the numbers in my original trail balance, the data doesn't change in my pivot or dashboard?
Even if i deleted all data in trail balance still see numbers in pivot and dashboard?
Is there mistake i made and in which part?
After refreshing?
@FinexSkillsHub I should do (load to) from the queries and connections each time I changed the numbers or add numbers.
So if it's the only way then thanks your video is amazing actually and I learned a lot of it💯,
And if there is another way faster, it will make the video perfect!
@@mortyfarj Yes. The numbers should update when the data changes. You just have to refresh.