Not applicable
2015-02-12
09:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum of december of Last Year and Variation of January this year
Hello everyone,
I am try to write a formule to sum the value of december of Last Year and Variation of January this year, but I can't make it work.
Here's a simplified version:
I have a table like this
and I want to make the table below:
but with the formule I write :
=sum({<Year={$(=max(Year)-1)},Month=>}Sales) +sum({<Month={'janv.'}>}Variation)
I get 10 for January 2015 instead of 100+10=110
How should I modify the formula?
Thanks a lot!
278 Views
2 Replies
2015-02-12
09:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set analysis won't work. The set is calculated at the chart level, not the row level. Try rangesum(above([Sales last year]),variation).
talk is cheap, supply exceeds demand
199 Views
Not applicable
2015-02-20
12:14 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your reply, but once I used
=RangeSum(Above([Sales last year]),Variation)
my Jan. value is right, but not Feb. value:
Can you please advise ?
Thanks alot!
199 Views