I have a problem about ytd calculation on pivot table. I atteched an example which has the same problem. On the example as you see I ve 2 expression, first one is my formula which is not working properley, second one is basic sum calculation. I need to show ytd calculation by month. I mean if i pick februray on list box, i should see just februray column and it should be january+februray. Wıth my formula, I got true calculation on februrary but january's column also coming with februrary's calculation which shouldn't be come.
On the other hand user can pick more than 1 months, if march and april picked, pivot table should show these 2 months with ytd by their calculation.
Hi settu, thanks for your reply but it is not what i need, I need to get ytd calculation by month, with your formula I get just sum sales between 2 dates by month 😞
