2 Replies Latest reply on Feb 5, 2018 9:47 PM by Samanth Yadav

    Calculation

    Samanth Yadav

      Hi All,

      Shinichiro Murakami

      Right now the dashboard which I’m using if I select a single month or quarter the dashboard shows the Beginning and Ending Balance of that Particular Month or Quarter but if I select 2 options as in Q3 2017 and Q4 2017 it shows the Beginning Balance as of Q3 2076 and Ending Balance as of Q4 2017. Is there any calculation by which we can show the Ending Balance as of Q3 2017 and Ending Balance as of Q4 2017?

       

      So If I select a single month or quarter it should show the Beginning and Ending Balance of that Particular Month or Quarter but if I select 2 options as in Q3 2017 and Q4 2017 it should show the Ending Balance as of Q3 2017 and Ending Balance as of Q4 2017.

       

      Monthly-Quarterly Balance.PNG

       

      Ending Balance.PNG

       

      Attached is the Workbook.

       

      Thank you.

       

      Samanth