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. Sorry for late response, been away for a while. You are correct but number of weeks is not static. Number weeks selected depends on the user but expression will calculate for number of weeks selected. See example below.
I think what saimahasan provided is what you would need. Go to the presentation tab and try selecting enabling 'Show Partial Sum' for your Week Number of Year dimension and no matter how many weeks you have, the end result will be the just one column for each of your expression. Give it a try as there is no cost of trying in QlikView.