Post reply

Dynamic Grouping with aggregate function

  • November 28, 2013 at 5:00 am

    #286879

    Hi,

    I want to do dynamic grouping at report level which includes aggregate function

    The logic i want to write is

    =(Floor((A/(Ceiling((Max(A) - Min(A))/Round(Log(CountDistinct(B))))))))+1

    Note: Datasource is based on SSAS Cube

    Please let me know if any have has done such type of grouping or any one has some ideas on how to implement

  • December 6, 2013 at 1:31 am

    #1671399

    I remember that you can't use Aggregate function for a group expression. You can use just "RowNumber()" and all Maths expression. You can't use Max or Min, so you need to build this field in MDX query

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply