Forum Discussion
Group By with some data split over categories
Hi Jonas_Bertels ,
If you want to show 0 in matrix, you could refer to below table in my sample, if not, you could refer to first table in my sample.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Amitchandak,
Thank you for this solution, it does work. As a follow-up question, is it possible to add 2 columns to this matrix? One where we take the percentage of type 1 hours and type 2 hours over all hours (type 1+2+3) (in %), and one where we take the type 1 hours over the total hours (in %).
Hi Jonas_Bertels ,
If you want to show 0 in matrix, you could refer to below table in my sample, if not, you could refer to first table in my sample.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.