I'm trying to create a report that presents subtotals and a total.
I know Member Sorting & Grouping function for calculating subtotals - Please refer to the screenshot attached to this discussion.
Does anyone knows how to calculate total?
Also is there an EPM function to calculate subtotal or total? The reason I'm asking about EPM function is I was told that using excel function slows down performance compared to using EPM function when data volume is huge.
Thanks in advance.