Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this:
Sum({<anoVtaCab>} sales)
Now any selections made in anoVtaCab field won't reflect on the chart anymore
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>}
Im just using the year field anoVtaCab... its only contain the year...
Where are you using this? Can you share an image to clarify what you have?
here, i use the year as a colum, but i dont want this colum to be afected by a filter
what is your expression here?
only "anoVtaCab"
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)
Measure is SUM(sales), rows is vendors, and colums is just anoVtaCab
Try this:
Sum({<anoVtaCab>} sales)
Now any selections made in anoVtaCab field won't reflect on the chart anymore