Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
been struggling over this one for a while and cannot find a solution.
i have a matrix displaing financial information (Profit and Loss)
The Matrix is split by headers in the rows, Months across the columns
Example below
My issue is that the Total row at the bottom of the table displays the final net profit as a negative of the true Net profit
i alter the values within each row header to reflect a report view of the figures instead of the values need for the calculation.
this has lead to some confusion as users read the total line instead of the net profit line and draw the wrong conclusions. unfortunatly i cant fix people
is there away to remove this total line, in my other tables i simply set grand totals to white text on white back ground to remove the line
however in this table i cannot do this as i still need the grand total in the right hand colunm to display the year total.
Any thoughts?
Proud to be a Super User!
Solved! Go to Solution.
Hi @AnthonyTilley ,
What about this?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AnthonyTilley ,
Have you tried this?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunatly i cannot remove subtotals as these are still needed for the idividual levels within the table when the table is expanded to the second level.
Proud to be a Super User!
Hi @AnthonyTilley ,
What about this?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |