I am using the before function and it works fine, the problem is that I need a value in the total column. I have 2 dimensions, groups and weeks. the final value for each group needs to be added to give me a total value. Any help would be appreciated.
I am not sure if I got your request properly, but I think you could get what you want if you combine dimnesionality() to check if your on total line, bottom() to get the last line and advanced aggregation to rebuild the table on total line virtually, maby like
The exact expression will depend on the orientation of your pivot dimensions, so I added two examples with dimensions in horizontal or vertical orientation.
I am not sure if I got your request properly, but I think you could get what you want if you combine dimnesionality() to check if your on total line, bottom() to get the last line and advanced aggregation to rebuild the table on total line virtually, maby like
The exact expression will depend on the orientation of your pivot dimensions, so I added two examples with dimensions in horizontal or vertical orientation.
