Pivot filtering

[Anonymous]

Hi,

I would like to be able to fix the weeknum columns to only show columns for weeks 7 to 10?

Not sure how to do this - via sort expression or dimension calculation? What do you suggest, and how?

[marcus_sommer · Accepted solution]

You could use a calculated dimension like: if(Weeknum >= 7, Weeknum) or using a set analysis condition within your expressions like: sum({< Weeknum = {">=7"}>} VALUE).

- Marcus