Value not displayed when there's no Revenue

building reports desktopintelligence
1

Hi,

I have a report that shows daily revenue for each region. When there’s no revenue for that region for the day then the region is not displayed. What can i do at the report level to make all regions displayed even there’s no revenue for a particular region?

I tried adding $0.001 to the measure however it still won’t show that region.

appreciate any help.

BOaddictNYC (BOB member since 2003-07-11)

2

Introduce a new data provide with distinct region name (just the region object). Link the two region objects. This would display any region name even if there are no measure.

KhoushikTTT :us: (BOB member since 2005-02-24)