2 Replies Latest reply on Mar 16, 2017 11:01 AM by dipti.patel.2

Cumulative SUM across Months

dipti.patel.2 Mar 14, 2017 12:52 PM

For the below table I want to count the quantity to be cumulative across Months starting Jan

So for Furniture > Bookcases > January > Quantity is 14

And for Furniture > Bookcases > February > Quantity is 2

So when a user select Jan since its the first month the actual quantity values are shown.

But when a user selects Feb then I want the quantity to be 14 + 2 = 16

So on then as user selects other months going forward for that year.

How do I achieve this?

Jan -

Feb -

1. Re: Cumulative SUM across Months

Norbert Maijoor Mar 14, 2017 1:10 PM (in response to dipti.patel.2)
Hi Dipti,

Find my approach as reference below and stored in attached workbook version 10.0 located in the original thread.

Date selector

Quantity selected: if datediff('year',[Order Date],[Date selector])=0 and datediff('month',[Order Date],[Date selector])>=0 then [Quantity] END

Regards,
Norbert

sample 12_DP_10.0 Running Sum_nalmai.twbx 1.2 MB
Like Show 0 Likes(0)

Actions
2. Re: Cumulative SUM across Months

dipti.patel.2 Mar 16, 2017 11:01 AM (in response to Norbert Maijoor)

Hi Norbert,

Thanks for your help, but is there any other way to do it other than using the Order Date as in my current data set I do not have any dates but just Month and Year as a separate columns.

I will also try out if possible without using any date field
Like Show 0 Likes(0)

Actions

Tableau Community Forums