Forum Discussion
Editing the Row Subtotal Aggregate Calculation on Matrix Table
I have a matrix table were I get the top five accounts for a quarter using the rank system built in PBI, the issue I'm having is that the [revenue_share] row subtotal is giving me the average of the percentages of the top five accounts, when what I need is the sum of the percentages (which would be the value under [Top 5 rev share] column. Is there a way to get the sum of precentages in the row subtotal instead of the averages?
This worked! The only change that I did was this:
rev_share_adj = Sumx(Values(Table[revenue_share]), Table[revenue_share])
4 Replies
This worked! The only change that I did was this:
rev_share_adj = Sumx(Values(Table[revenue_share]), Table[revenue_share])
Hi,
Share the download link of the PBI file.
I have another question amitchandak .
How can I sort first by year-quarter, and then by recognized revenue?
Basically what I need is for the order of Y-Q to be ascending and the recognized revenue to be descending once the matrix is expanded.
