Show field when no data allocated

[#1]

Hello,

Im sure this has been asked before but I cant find anything in search.

I have had a request to :

Show field entries where there is no entry in the dimention.

Example:

Normal : Select Customer , show Products and product prices

Required : Select customer, show products where there are no prices allocated to that customer.

Im going in cirlces and im sure there must be a simple solution!

Thank you in advance.

[#2]

Note: I cant really use select excluded as its select customer first, not select product then select excluded if that makes sense.

[jagan]

Hi,

Can you attach sample file.

Regards,

Jagan.

[#4]

Hi,

You could use an IF clause in the dimensions of a pivot table and suppress null. Example:

if(IsNull(Price), Product)

Regards,

sebablum

[#5]

Hello - This iis a better explination of what I require.

Data : Company A Product ZZ  Price 10

           Company A Product XX Price  10

           Company B Product ZZ Price 10

           Company B Product CC price 20

regular selections for company A would bring up  Dimention (Products) and expression Price

Result :     Selection Company A

               Table: Product  ZZ Price 10

                         Product XX Price 10

What I require to show with Company A still as selection is :

Desired Result :

               Table : Product CC Price 20

-- As in All products that do not have a price allocated to company A

Basically in the data set there is no entry for product CC for company A but tis this which I wish to display ie a mirror image of possible.

Anyone ideas?