Using the new Automatic Fill-Up property is very easy. Let’s extend the crosstab from the last post in this manner. While it’s not the worst case with one quarter missing in-between, it’s still a good use case for the new feature – we don’t really want the crosstab to start in Q3/2015 (where Northwind Traders obviously started to get into business) but want to have columns for Q1 and Q2 as well. This makes it much easier to visually compare the years 2015 and 2016. The way the crosstab looks by default, this comparison would be hard to do:
So we simply select the header for the quarter in the crosstab and set it’s Automatic Fill-Up property as required:
The resulting crosstab then looks like this:
Which allows for easy comparison:
This feature can easily be used to fill up missing months, years, days etc. as well. This adds even more flexibility to the crosstab in LL22 – it’s almost perfect now ;).
Leading the development at combit as Managing Director. Microsoft .NET enthusiast driving innovation & agile project management. Used to be a physicist in my first life. I love hiking and vanlife.
