When pivoting the table view, can we get the ability to sum metrics by row? Using the row total just give null value, and using column totals sums the column of the pivot

👋 Thanks for your message - someone from the Lightdash support team will get back to you asap. Feel free to add any additional context to the thread here in the meantime (screenshots, app version if you're self-hosting etc.).

Hi Colby, can you confirm what metric types you are using? (sum, count, number) Are row totals working for you at all? Or all are blank? I just tested on my side and I'm not able to reproduce any issues with pivot row totals.

sum metrics

Are you building something like this demo example? You can see the row totals work as expected there. If you have a more complex setup can you make sure the blank totals are in view on your screen, then submit a support report (see image)?

Yeah your demo is built exactly like mine. I'll submit a support report. Thanks Jake!