cumm Sum

[#1]

Hi All,

I have the data on date level.

I want to calculate cumulative sum of the Sales for category A.

My formula is sum({<Flag={'A'}>}Sales) .

How to write the cumulative sum for the selected month for each year.

Thanks in advance.

[sunny_talwar]

What is the number you are expecting to see here?

[sunny_talwar · Accepted solution]

May be this:

='Cummulative Category A Sales ' & Num(Sum({<Flag={'A'}, MonthYear = {"$(='>=' & Date(YearStart(Max(MonthYear)), 'MMM-YY') & '<=' & Date(Max(MonthYear), 'MMM-YY'))"}, Month>}Sales),'#,##0.00')

[ziadm]

Hi

Create another AsofTable and make MonthYear as the  key to link your sales table with the AsofTable

AsofMonth:

load

MonthYear ,

Sum(Sales) as MonthSale

Resident Dept_Sales

Group by MonthYear;

The formula will be

sum({<Flag={'A'}>} MonthSale )