Sum with base value

[marcelpinheiro]

Hello everyone.

I have a bar graphic with 5 days of week. I have 3 columns: Received values, bills to pay and balance.

The balance formula is (BASE VALUE+RECEIVED VALUES - BILLS TO PAY)

My problem is: I need the base value SUM only one time, bring the balance to the next day and then SUM with the received values and subtract BILLS to pay.

Example:
MONDAY:
BALANCE = BASE VALUE+RECEIVED VALUES - BILLS TO PAY
TUESDAY:
BALANCE = BALANCE OF YESTERDAY + RECEIVED VALUES - BILLS TO PAY

Can anyone help?

[v-chuncz-msft]

@marcelpinheiro,

To apply cumulative total, you may take a look at this article.

[Ashish_Mathur]

Hi,

Share the link from where i can download your file.  Also, show the expected result there.

[marcelpinheiro]

Hello everyone.

I have a bar graphic with 5 days of week. I have 3 columns: Received values, bills to pay and balance.

The balance formula is (BASE VALUE+RECEIVED VALUES - BILLS TO PAY)

My problem is: I need the base value SUM only one time, bring the balance to the next day and then SUM with the received values and subtract BILLS to pay.

Example:
MONDAY:
BALANCE = BASE VALUE+RECEIVED VALUES - BILLS TO PAY
TUESDAY:
BALANCE = BALANCE OF YESTERDAY + RECEIVED VALUES - BILLS TO PAY

Can anyone help?