Patrick, it is great video how to calculate cummulative values. I did not think that it is so easy. I'm interesting how you did those white boxes with years - they are interactively change in size when you use a slicer. Can you comment on this - I did not found a video for this .
That's amazing @Patrick. However, please explain what if I wish to condition the Cumulative Curve to look for a value in a column and lookup for corresponding date in other column to end let's say Feb 2019. I mean to say I wish to cumulate the cost with a condition that if column contains value 'x' in col A then consider the max date in col B and do the cumulative sum. Max date encountered in col B with "X" in col A is 21-Feb-2019 so the curve should disappear from Mar-2019 onwards. How do we achieve this?
Hey Mate - great video, thank you for the content. I have a question, I have an initial contract budget value column (one record) in one table and a column with many contract change orders in another table. How can I create a running total that starts with that initial contract budget value column and the running total is based on contract change orders. Let me know if you can help! Thanks in advance
Boa tarde Estou tentando efetuar uma soma acumulada. Que funcione da seguinte forma. Ex : tenho três ano na base, 2020 a 2022 , quando selecionar o ano primeiro retorne a soma do ano. Depois quando for filtrar pelo mês quero que traga a soma do mês selecionado mais os meses anteriores. Ano 2021 , 1.528. qnd selecionar o mês de abril , a soma de abril + os meses anteriores correspondente ao ano filtrado. Alguém já realizou algo nesse sentido.
So happy this video had background music to help subdue that horrible ringing sound.
Patrick, it is great video how to calculate cummulative values. I did not think that it is so easy.
I'm interesting how you did those white boxes with years - they are interactively change in size when you use a slicer. Can you comment on this - I did not found a video for this .
That's amazing @Patrick. However, please explain what if I wish to condition the Cumulative Curve to look for a value in a column and lookup for corresponding date in other column to end let's say Feb 2019. I mean to say I wish to cumulate the cost with a condition that if column contains value 'x' in col A then consider the max date in col B and do the cumulative sum. Max date encountered in col B with "X" in col A is 21-Feb-2019 so the curve should disappear from Mar-2019 onwards. How do we achieve this?
Thnx man!
Hey Mate - great video, thank you for the content. I have a question, I have an initial contract budget value column (one record) in one table and a column with many contract change orders in another table. How can I create a running total that starts with that initial contract budget value column and the running total is based on contract change orders. Let me know if you can help! Thanks in advance
Muito bom !!!
Thanks!
Boa tarde
Estou tentando efetuar uma soma acumulada. Que funcione da seguinte forma.
Ex : tenho três ano na base, 2020 a 2022 , quando selecionar o ano primeiro retorne a soma do ano. Depois quando for filtrar pelo mês quero que traga a soma do mês selecionado mais os meses anteriores.
Ano 2021 , 1.528. qnd selecionar o mês de abril , a soma de abril + os meses anteriores correspondente ao ano filtrado.
Alguém já realizou algo nesse sentido.
Moving around the screen like that is a great distraction