Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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')
What is the number you are expecting to see here?
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')
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 )