0

Custom Groupings

 

 

Hi,

Is it possible to create custom groups or show a different field name? I know we can produce sets, but this doesn't quite achieve what I would like to see as sets filter the data.

This is to get around multiple client names or long names.

Our data comes from an SSAS Cube. 

Thanks,

Ben

3 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 2 yrs ago
    • Reported - view

    Hi Ben,

    I'm not sure that I quite understand what you are trying to do. Can you give me a bit more explanation?

    Thanks,

    Ian

    • Ben_Burchell
    • 2 yrs ago
    • Reported - view

    Hi Ian,

    I was able to get very close to what I was looking for.

    Create an aggregate formula for the member names you need. Overwrite the dynamic caption.

    E.g. Aggregate({{[Alphabet].&[A],[Alphabet].&[B],[Alphabet].&[C]}})

    Dynamic Caption "ABC".

    It can be temperamental if the member is in a larger hierarchy.

    Thanks,

    Ben

    • Senior Director of Product
    • Ian_Macdonald
    • 2 yrs ago
    • Reported - view

    Hi Ben,

    OK, so do you need any further help on this?

    Ian

Login to reply

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 3Replies
  • 60Views
  • 2 Following