Search:

Type: Posts; User: Ppivot; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    396

    Re: Fighting with RANKX function

    I think I have it, thank you a lot for your Tip!!!!

    The formula: (If it can help to others)


    Calculate(

    RANKX( ALL(Table[ID] , SUM(Table[Net Sales] ) ,
    ALLEXCEPT( Table,...
  2. Replies
    4
    Views
    396

    Re: Fighting with RANKX function

    Nor with the Year, itīs seems that doesn't be affected by the filters (Year and Category)
  3. Replies
    4
    Views
    396

    Re: Fighting with RANKX function

    Thank you Matt, it almost work but not completely. I mean, it works great with totals however when I introduce the Product Category in the Columns, the result is not correct.

    I attached the file...
  4. Replies
    4
    Views
    396

    Fighting with RANKX function

    Hello Guys!!

    Iīve been fighting for all day long with the function RANKX and I canīt be able to find a solution:

    The function is simple but it doesnīt work as I expected:

    I want to do a...
Results 1 to 4 of 4