I have a requirement of showing category expenses in different columns, Let me take an example, Monthly expenses of flat rooms that may be the water bill, electricity bill, maintenance charges, and so on.
But some of the flats have a missing category, I need to have "0" to show at the missing category. Is there anyway without including it in data level??
If I understood it clearly, you can create a calculate field like:
If Category='Water bill' then sum(expense) end, just like this you need to create a separate calculations for different categories.