Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everyone;
i have the next table with mesure acumulate
for month march total acum for 3 months
total acum 600
Jan 100
Feb 200
Mar 300
for month february total acum for 3 months
total acum 350
dic 50
Jan 100
Feb 200
for month january total acum for 3 months
total Acum 500
Nov 100
Dic 300
Jan 100
how i get a table with the acumulate for this way
over the total
Jan 500
Feb 350
Mar 600
Use RangeSum() along with Above() :
under expression
Accumulation--> Accumulate --> 3 steps back
Hi Petter thanks for your response but doesn't work because when i have select a dimention year if you seen the acumulate it make it this way:
March = March+February +January
Feb = February +January+December
January= January+December+November
December = December +November
I make the test with this in my application and doesn´t work i don´t know what´s going on
the acumulate is make this way: if i select YEAR=2015 thae acumulate :
March = March+February +January
Ferburary=February +January
Janury = January
I neet this way
Hi,
if you are doing it in UI side use Accumalation. If it is expression/script go for Rangesum with Above or Below based on your requirement.
To achieve what you want you will have to have an additional field which is composed of Year and Month like this:
Year(Date) & '-' & Month(Date) AS YearMonth
then YearMonth will be the field you use in your expression as this will give you consequtive months which will traverse years... The Above() function will then be able to find previous (Above) months even in January and Febuary
Hi,
Try like this,
Dimension:
any one field name (Month_Name)
Expression:
Sum(First Table Value)+Sum(Second Table Value)+Sum(Third Table Value)
Hi,
I will look to bring the accumulated field in from the script. Reason is you can take advantage of PEEK() function.
Example
Final_Table:
LOAD
A,B
IF(Month = Peek(Month),RangeSum(FigureFieldName,Peek(AccumulatedField)),FigureFieldName) AS AccumulatedField
RESIDENT Temp_Table
And Order By A,B;
Drop table FigureFieldName;
Hope this helps
Petter really and also people thanks for your help
i did what you said petter and i added a new dimention with the Year and month in this way 201501inside of the table and just work it when i don't select any dimention in
year or month what i mean is that when i select year 2015 and current month is cut te measure. i try to put this in my first expression like a set analysis sum({$<Year=>} measure)
after my second expression rangesum(Above(test,0,3))