Missing data

[#1]

Hi,

Please have a look at the attached image. I need to make surethat all the stores for the selected retailer are always visible. The problem Ihave is when all products have not been sold in a particular store, then thatstore would not be listed in the pivot table as there is no data for thecurrent selection.

How can I always display all the stores for a selectedretailer regardless of if it had sales or any other selections?

Thanks

[goldnejea8]

In the Load script you could do something like this:

if(len(trim(Sales))<>0,sales,'0.00') as sales