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
You should probably check the rank of the list of children of dimension 1 current member… case when zero then property, else empty
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