filtering dimension

[#1]

Hi,

I have the Question 1 to 15 in the pivot table and i want to display only Question 1 to 10. How can i filter the questions in dimensions.

Please help.

[#2 · Accepted solution]

just make it a calculated dimension

if (Match(Questions,'Q1','Q2',..'Q10'),Questions)

And then tick the check box "Suppress when Value is NULL'