Use field in db for static colum

[#1]

I have a problem that seems easy to solve but i can't make it...

For a pivot table i use an field in sql db "anoVtaCab"... Then in the filter i have all the years (2010 - 2011 - 2012 - 2013 - 2014 - 2015 - 2016)... When i selected for example year 2013 the table only leave the 2013 colum, but i dont want this ... i want the columns on this table (only) to ignore the selection... how can i do?

[sunny_talwar]

What expression are you using? If you want to ignore all selections, you can add {1}. If you are looking to ignore specific selections, you can list them out like this {<FieldName1, FieldName2, FieldName3>}

[#3]

Im just using the year field anoVtaCab... its only contain the year...

[sunny_talwar]

Where are you using this? Can you share an image to clarify what you have?

[#5]

here, i use the year as a colum, but i dont want this colum to be afected by a filter

[sunny_talwar]

what is your expression here?

[#7]

only "anoVtaCab"

[sunny_talwar]

Isn't anoVtaCab your dimension which is just a name for Year??? Or is this truly an expression? I am looking for the measure? If it is, then try this

Only({<Year>} anoVtaCab)

[#9]

Measure is SUM(sales), rows is vendors, and colums is just anoVtaCab

[sunny_talwar · Accepted solution]

Try this:

Sum({<anoVtaCab>} sales)

Now any selections made in anoVtaCab field won't reflect on the chart anymore