Forum Discussion
Solved
Matrix - row total formula
Hello, I have line items (rows) in a matrix and I would need the Total to be calculated differently for different line Items. For ex, it needs to add all monthly values for one and avg for others...
Bhavesh and Angelia, thanks for your response.
For now, i got around the problem by getting the Yearly totals from the source itself. This is being calculated in the source data so i am able to pull it in.
But surely would like to know how such requirements (P&L items) are handled in Power BI. Looks like there is better control in excel as we can manipulate (even in terms of formatting) at cell level once the pivot table is placed on the sheet.
Thank you,
Harisha
Hi Harisha,
For the exact solution of your problem, please visit this blog post from Rob Collie which will give you more ideas on creating such grand totals.