I have two expressions, one for sum and one for avg that is displayed in columns under each selected week from list table (number of columns change depending on the number of weeks selected. I would like to add grand total columns for the sum and avg expression as the last two columns. My problem is that when I created the grand total expression it's being displayed for each week with wrong data of course. Any help will be appreciated.
Thanks. I actually went a different route by having the grand total before the weeks. Since the number of weeks displayed could be quite long depending on the user, seeing the grand totals without having to scroll all the way right was more prudent. Since it's a pivot table, a user can then un-collapse the grand total to see selected weeks if desired.
