Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In the Load script you could do something like this:
if(len(trim(Sales))<>0,sales,'0.00') as sales