1

Rank a simple list

I have a simple aggregated list of <group>, <measure> to which I'd like to add a rank column.   I'm not seeing a way to rank the <group> items without a parent group existing in the report.

e.g.  Product Category, Product Subcategory, Product, Total Rev, Rank within subcategory   <<< works 

        Product, Total Rev, Rank within report  << How do I get this to work?

 

I've worked around this by inserting a formula column with a space (  " " ) and then using groupBy(" ") but that has the unfortunate side effect  of showing up as a column in the aggregate table.  

 

Can I rank a simple aggregated list without a defined and displayed parent grouping?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Ah - as is so often the case as soon as I give up the ghost and publish a question I find the answer.

     

    Although the 'groupBy' *function* appears to be mandatory, it is not mandatory to actually pass a dimension parameter to it.

     

    From sample data: 

     

    rank(

        groupBy(),   /* Wouldn't it be great to be able to comment about this empty () here?  */    

        orderBy(

            sum(

                Online_Store.RevenueDetail.LineTotal

            ), 

            false

        )

    )

    Like 1
Like1 Follow
  • Status Answered
  • 1 Likes
  • 3 mths agoLast active
  • 1Replies
  • 33Views
  • 1 Following

Product Announcement

Incorta 5 is now Generally Available