Ytd by month on pivot table

berkarmagan — Wed, 25 Nov 2015 22:00:47 GMT

Hi everyone,

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.

Thanks for now.

Re: Ytd by month on pivot table

settu_periasamy — Thu, 26 Nov 2015 02:08:40 GMT

Hi,

Check the Attachment.

Re: Ytd by month on pivot table

berkarmagan — Thu, 26 Nov 2015 05:27:43 GMT

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 😞

topic Ytd by month on pivot table in QlikView

Ytd by month on pivot table

Re: Ytd by month on pivot table

Re: Ytd by month on pivot table