Report with 2 dimensions in rows

Questions & Answers
1

Hi,
I have a report with 2 dimensions on rows and I would like to display a property of the first dimension member.
When I expand dimension 1 member, the property is displayed on all rows and I would like to display it only on the first row because it’s the same value (for 1 dimension 1 member, I have more dimension 2 members).
How could this be achieved? Thank you

image
image1090×174 9.06 KB

2

You should probably check the rank of the list of children of dimension 1 current member… case when zero then property, else empty

1 Like
3

Hi Laura_Iacob
Thank’s for eaching out!

You could try the following formula:

CASE WHEN
    Rank(
      CurrentTuple(VisibleRowsSet()).Item(0),
      VisibleRowsSet())
    = CumulativeSum(1)
THEN
CurrentTuple(VisibleRowsSet()).Item(0).CurrentMember.Name
END

Kindly,
Ilze

1 Like
4

Hi Ilze,

Thank you so much, it works really well, I added my property instead of the name of the current member and it works exactly how I wanted.

Regards,
Laura