Hello,
I have a simple pivot table where showing percentage of sales by the product;
I seem to have what I want but in one of the category's (product id) there is not sales value so the total is put in instead.
I've solved the problem by using if isfiltered rather than if hasonevalue which worked where there was one.
Could someone point me in the direction of some information on this as at the moment it's a bit trial
I've attached the workbook, showing the two examples Showing the problem (product D id 44 ) l and error.
The two measures are : % of Sales by Product is filtered and % of Sales by Product One Value.
Richard
Bookmarks