Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Note: I cant really use select excluded as its select customer first, not select product then select excluded if that makes sense.
Hi,
Can you attach sample file.
Regards,
Jagan.
Hi,
You could use an IF clause in the dimensions of a pivot table and suppress null. Example:
if(IsNull(Price), Product)
Regards,
sebablum
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?