Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to make a graphic which shows the total sum of the field [AMOUNT] until the variable LASTDATE but group by the Dimension CalendarMonthAndYear (defined this way : MONTH("Date") & '-' & YEAR("Date")):
For example:
Jan-2011 = 10
Feb-2011=20
Mar-2011=30
The graph should to show
Jan-2011=10
Feb-2011=30
Mar-2011=60
HOw Should I set the sum analysis formula?
any idea?
Thanks and happy weekend
Here is an example.
Have you tried using Chart Properties > Expressions > Full Accumulation?
Here is an example.
Ok, I`ll try and let you konw. Thanks
If that doesn´t work, try this, although I recommend you to make a master calendar and have fields Year, Month, MonthAndYear.... etc separately
aggr(sum(total Amount), MonthName(Date))
hope this helps
Thanks you both for your time!