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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Watch MrExcel Video

Forum statistics

Threads
1,102,287
Messages
5,485,902
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top