Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with two dimensions.
For each row in the first dimension, I would like to show only the first row in the second dimension.
For instance, let say I have the dimensions ACCOUNT and TRANSACTION, with several TRANSACTIONS per ACCOUNT
ACCOUNT TRANSACTION
Acc1 T1
Acc1 T2
Acc1 T3
Acc2 T5
should be displayed as
ACCOUNT TRANSACTION
Acc1 T1
Acc2 T5
I want to achieve so using an expression in a calculated dimension or an option for the sheet object
I cannot see the .qvw. Would you like to describe briefly the content ?