Report Portal

Named Sets and "Asymmetric" Pivots: Showing Different Measures for Different Years

This is crazy. I was positive I'd blogged about Named Sets. But I searched, and it seems like I haven't. Ever. And this is one of those cool little (and simple!) tricks that we all need from time to time.

OK. You cannot just filter out a measure in some places. It's either on the pivot, or it's not. Does that mean we're stumped? Nope, we just need to use a different feature:


Tags: excel, design, tabular


2007-2015 VidasSoft Systems Inc.