dbTalk Databases Forums  

Displaying data for empty values

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Displaying data for empty values in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
pierrot
 
Posts: n/a

Default Displaying data for empty values - 07-03-2003 , 03:08 AM







Hi,

I have a sales cube that is used in a PivotTable in Excel XP to show
daily sales by Store.

The user would like to see always the complete list of stores even
though there is no sale for specific stores. Currently if the store does
not have any sale in a specific day the Store name is removed from the
PivotTable.

Thanks for your help.

--
Posted via http://dbforums.com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.