Replace Category and amount fields with this calculation below and try it out
IIF ( ISNULL([Category],type,[Category])
How about the charges?
Ahmad you have to take charges out as it act as separate measures. We can't embed the charges header in category dimension.
Create a calculation
Add add this as a seperate report and append it on the dashboard
lmäo. not helpful.