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.
Super UserJonas_Bertels , if you take a matrix and put a person on row, project type on column and hours on values (Take summarization as sum)
It should work
If you need exact text then create a new column like
New Project Type = "Time - projecttype " & [Project Type]
Use this on column
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 %).
daxCommunity Support
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.
