Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem with the Above () function in a table.
I have a simple table like :
Name Surname Year Sales Above(max(Salese))
A T 2015 1000 800
A T 2014 800 1500
A T 2013 1500 -
B U 2015 800 900
B U 2014 900 700
B U 2013 700 -
The problem is, the Above() function work just if in the table I have 2 dimension (Name and Year).
Once I try to add more dimension the function doesn't work anymore.
How I can exclude the other dimension in the function and just considering for instance above(Sales) of the Year just on Name, Surname.
Thanks for any helps
Best
Can you try this
Aggr(Above(Sum(Sales)), Name, Year)
or
Aggr(Below(Sum(Sales)), Name, Year)
Nobody can help ?
Thanks
Sure, table with 2 dimension Name and Year works fine
Name Year Above(max(Salese))
A 2015 800
A 2014 1500
A 2013 -
B 2015 900
B 2014 700
B 2013 -
table with Name Surname Year Sales the Above() doen't work.
Name Surname Year Sales Above(max(Salese))
A T 2015 1000 -
A T 2014 800 -
A T 2013 1500 -
B U 2015 800 -
B U 2014 900 -
B U 2013 700 -
It will be good if the function will always works.
look that above with all dimension is on all of them. But I would force the above just on the name and year.
Best
Sure, table with 2 dimension Name and Year works fine
Name Year Above(max(Salese))
A 2015 800
A 2014 1500
A 2013 -
B 2015 900
B 2014 700
B 2013 -
table with Name Surname Year Sales the Above() doen't work.
Name Surname Year Sales Above(max(Salese))
A T 2015 1000 -
A T 2014 800 -
A T 2013 1500 -
B U 2015 800 -
B U 2014 900 -
B U 2013 700 -
It will be good if the function will always works.
look that above with all dimension is on all of them. But I would force the above just on the name and year.
Best
Sure, table with 2 dimension Name and Year works fine
Name Year Above(max(Salese))
A 2015 800
A 2014 1500
A 2013 -
B 2015 900
B 2014 700
B 2013 -
table with Name Surname Year Sales the Above() doen't work.
Name Surname Year Sales Above(max(Salese))
A T 2015 1000 -
A T 2014 800 -
A T 2013 1500 -
B U 2015 800 -
B U 2014 900 -
B U 2013 700 -
It will be good if the function will always works.
look that above with all dimension is on all of them. But I would force the above just on the name and year.
Best
Can you try this
Aggr(Above(Sum(Sales)), Name, Year)
or
Aggr(Below(Sum(Sales)), Name, Year)