Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to view my financials by year but I want to exclude the two bottoms ends. I do not want to see 2015 and 2020, which are at the ends of what I am trying to view. Is there a way to limit the display of the table's columns to 2016-2019.
Thanks,
Yes, Year is the dimension
no luck here either
I just tried it in the pivot table dimension area as well and it does not work
When I say expression... I mean measure
so we have a pivot table with years displayed as the columns and lots of measures populating the rows. All we want to do is not display the first and last year columns somehow.
Sum( {Year =- {2015,2020} >} Revenue)
This should work. Replace Revenue with your metric field that you are using.
MATCH(if(Year <> 2015 or Year <>2020))