Display only certain value in dimension in straight table/pivot tale

[Amelia_96]

Hi, i have another problem where in one dimension, let say status got 5 values which is Paid, Pending, Inforce, Cancelled and Terminated. But i just want to show Paid and Pending in the pivot table. How do i do this ya? Because when i select status as dimension, it will show all five status.

Please help me. Thank you!!

[GaryGiles · Accepted solution]

If you wanted to limited the values by only using the dimension field, you could use:

aggr(Only({$<Status={'Paid','Pending'}>} Status),Status)

Or, if you have a measure, just add {$<Status={'Paid','Pending'}>} as set analysis.

[Amelia_96]

It works! Thank you 🙂