Forum Discussion
Change column subtotal from average to sum
Hi. I just can't figure it out how to make one thing that looks pritty simple, but I still find it difficult to understand.
Column values "Evening", "Morning", "Night" are averages because I have set it up in the values field. Screen attached:
Also the "Total" column is showing me the average result. But is there any possibility to change it to sum function where it would sum the "Evening", "Morning" and "Night" columns? Or maybe there is some kind of formula, that could do it for me in the data table? Here is the screen shot of the table:
Basically I need to understand how many workers worked totally in one day, week or month, just sum up workers of all shifts that day.
Thank You in advance.
3 Replies
- Greg_Deckler
Community Champion
Sure, check out Matrix Measure Total Triple Threat Rock & Roll for the technique:
- kcantor
Community Champion
Anonymous
My reply was going to suggest writing an if statement substituting a Sum for Average if the calculation was not filtered on the row . . . but then Greg_Deckler dropped in the perfect reference for you before I typed up this reply.
Greg's reference shows you the basic format. All you need to do is change the calculations to fit your needs and you should be good to go.
- AnonymousNot applicable
But I still can't find how I need to change those calculations which Greg has provided that could fit my case.