Quicksight help!

Question

Dear friends,
Greetings.

I need help with a project in Quicksight that was delegated to me. I have the budget for 2023, where I have to add month by month the amounts spent. But I have not been able to find a way to add up the months to today.

I have the following table in Quicksight, the idea is that at the end of the current month it shows the sum of the previous months. I have been thinking about a kpi, I don't know if it is the right one.
![Enter image description here](/media/postImages/original/IMhqtxQZbGS1mOpD5HT6BcAw)

Answer

Hello,
Try `runningSum`
https://docs.aws.amazon.com/quicksight/latest/user/runningSum-function.html

This might be more than you need, but you might want to take a look at the [Cost Intelligence Dashboard Well-Architected Lab](https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/) as a way to visualize this and more.

> The Cost Intelligence Dashboard is a customizable and accessible dashboard to help create the foundation of your own cost management and optimization (FinOps) tool. Executives, directors, and other individuals within the CFO’s line of business or who manage cloud financials for an organization will find the Cloud Intelligence Dashboard easy to use and relevant to their use cases. Little to no technical knowledge or understanding of AWS Services is required. Out-of-the-box benefits of the CID include (but are not limited to): 
* Create chargeback or showback reports for internal business units, accounts, or cost centers. 
* Track how Savings Plans (SP), Reserved Instances (RI), and Spot Instance usage has impacted your unit metrics such as your average hourly cost of Amazon EC2.
* Keep track of which accounts or internal business units receive savings and when RIs and SPs expire.
    [Explore a sample Cost Intelligence Dashboard](https://d1s0yx3p3y3rah.cloudfront.net/anonymous-embed?dashboard=cid)

Quicksight help!

Relevant content