7 Replies Latest reply on Aug 21, 2013 1:44 PM by Matt Lutton

# Window Sum Table Calculation Help?

No sample workbook--I am hoping that someone can help based on my pill arrangement and the screenshot provided below.

I assumed I would be able to get the results I was looking for on this one, as I've successfully used some simple Table Calculations when needed--but I am at a loss in terms of understanding how to address this.  I want to display the total number of credits earned by Student ABC in the last column.  In this example, the total credits for Student ABC would be 28.  I have tried setting up a WINDOW_SUM, with compute using set to Name, but this is not working.  Perhaps it needs a more complicated setup.  If you can help me address this based on my screenshot, I would greatly appreciate it.  If a workbook is needed, I can mock one up later on but its not a huge priority at this point.

Thanks for any direction you may be able to provide on this one.  As always, I appreciate the folks who take time to look at problems on the forum!

• ###### 1. Re: Window Sum Table Calculation Help?

Matthew, take a look at this. Hopefully you'll be about to sub you dimensions for mine:

If you have troubles. Just create something in SuperStore and I'll help you edit it.

--Shawn

• ###### 2. Re: Window Sum Table Calculation Help?

Thanks, that helped.  Adding more fields to the "Addressing" enabled me to get the results at the level I wanted.  Now, it repeats the total in every row--how can I make it display only once, in the first row for that name?

Will IF Index()=1 do the trick here?

• ###### 3. Re: Window Sum Table Calculation Help?

I think I got it, thanks!

• ###### 4. Re: Window Sum Table Calculation Help?

IF FIRST()=0 will also probably work.

1 of 1 people found this helpful
• ###### 5. Re: Window Sum Table Calculation Help?

Just for posterity Matt,

You can also use something like IF FIRST () == 0 or LAST()==0 to create a T/F indicator that you can then filter on to only display the first/last record in a partition. Either of those, or using Index will introduce a table calculation that then depends on the addressing and partitioning Shawn pointed out before.

1 of 1 people found this helpful
• ###### 6. Re: Window Sum Table Calculation Help?

Dang, Shawn beat me to it!

• ###### 7. Re: Window Sum Table Calculation Help?

Thanks--I do appreciate all the help, guys!  I was able to get what I was after.