Show blank combinations in Pivot Table based on MS SQL

karaoan

New Member
Joined
Mar 14, 2017
Messages
1
Hi,

I am using a relational star scheme with fact and dimension tables (facts containing sales, product table contains product details etc.). Based on that I would like to use a pivot table that shows all products in rows or columns even if there is no record in the underlying fact table for that product. This is no problem with other sources e.g. PowerPivot as there is an option to "show blanks" in the Pivot table. This option is unfortunately not available with relational tables. Would appreciate if anyone has ideas apart from loading everything into a PowerPivot model.

Thanks!

Martin
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,099,684
Messages
5,470,111
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top