I decied to make a "hefty" report however not all infromation can be shown in the matrix table due to visible information limitations on the screen, therefore some information has been put to another page with the remainder of values that did not fit in the previous page.
The issue now that I can't overcome is showing the Rows sub total value as total as some filetered values are on another matrix table in another page.
How to show the cummulative total value of the row in the primary table that has been filtered to accomodate, the second table value just in case i can hide with the white line. There are other regions e.g. Europe IT however it fits fine. 20,811,931 + 30,615,179 = 51,427,110 Table 1 in Page 1
Table 2 in Page 2 - with left over values that not fit in page 1
Table Row Subtotal in Page 1 matrix table - should be
Page 1 Page 2
Page1 Subrow total: 54,989,306 + 26,896,931 = 81,886,237 Any ideas are appreciated.
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.