I have a table called product_dim where I have to eliminate the product_descripyion starting with GIFT or Gift.So, I have used the where clause in the load statement of product_dim as below:
where left(PRODUCT_DESCRIPTION,4)<>'GIFT' and left(PRODUCT_DESCRIPTION,4)<>'Gift'
I have to calculate the sum of sales of all the product except the above mention.I have Pivot table where it shows for product description starting with GIFT or Gift as '-' in the product_description column but shows values in sales column.
My requirement is that it should not show the corresponding sales amount also.
Hi, you can click on the properties of your char and go to dimensions tab, then you can select the option "supress when value is null". That should do the work.
Its not showing the product_description but on sales its adding the amount assigned to this product description.So even if I check this option or not my sum of sales is shown as same.
