Forum Discussion
Sum filtered rows with calculation in between
I have the following data in a matrix table, where Cups Phones and Fans are filtered from other objects (not displayed) Date Jan-2021 Feb-2021 Object ObjA 1 4 ObjB 2 5 ...
Thank you for your quick reply. I'm able to get those values, maybe the problem I'm having is more formatting than calculation? This is the desired output in a single visual / table. Is this possible? I'm currently able to get measure3_total in a separate table, and measure2_total in a separate table but I'm unsure of how to merge it with the value table to make one table
I've been poking around more - I think the solution may be something along the lines of what was done here (https://community.fabric.microsoft.com/t5/Desktop/Create-calculated-row/td-p/440613) but I don't entirely understand that solution yet. Still playing with it...