4 Replies Latest reply on Mar 12, 2018 7:38 AM by Michael Hesser

# "Sum by ..."

Hi,

I' m trying to build a sum by a dimmension. I want to sum the returns by day, so that I have a sum for each "day" {1,2,3.....,22).

Example:

Day1 (d1) : sum all returns with Day=1

Day2 (d2): sum all returns with Day=1 or Day2

Day3 (d3): sum all returns with Day=1 or Day=2 or Day=3

Thanks,

Enzo

• ###### 1. Re: "Sum by ..."

Hi Vincenzo--

Will a LOD calculation work for you?

SumByDate

{FIXED DATEPART('day', [Day]):SUM([return]}

This should give you the non-running sum of returns for each unique day.

Once you've plotted the non-running sum per day

• Right click on the SumByDate pill
• Select Edit Table Calculation
• Choose Running Sum.

Your detail may look like this:

(before running total)

(after Running Total)

Good luck!

• ###### 2. Re: "Sum by ..."

IF (ATTR([day])=1 OR ATTR([day])=  2) THEN RUNNING_SUM(SUM([return])) END

• ###### 3. Re: "Sum by ..."

Hi Michael,

thanks. The function doesn't work. Is it also possible to plot it as a table where you can filter by date?

• ###### 4. Re: "Sum by ..."

Hi Vincenzo;

Could you attach a .twbx please?

Also, can you describe what type of behavior you want to see when plotting as a table? For example: do you want the user to be able to see the running-sum for a particular day, without the the rest of the detail?

Do you just want to see it displayed as text, rather than plotted?

Or do you want the date range to reset based on what the user chooses to view?

Thanks! --Michael