Hi All,

Can anyone help me out in this.

I have below result,

C1 C1 C1

26-Nov-12 3-Dec-12 10-Dec-12

Count Of Product 196 162 210

% L Count 45.18% 40.49% 49.49%

% C Count 54.82% 59.51% 79.51%

% New Items 0.00% 0.00% 0.00%

Here in % New items i want to write MDX to show the product present for 10-Dec-12 but not in 3-Dec-12,03-Dec-12 but not in 26-Nov-12 according to this product present for 26-Nov-12 are 100% bcoz no previous date is selected.

thanks

Swapp