OTBI Dashboard to report Learning costs

Summary:

Hello,

I'm facing many difficulties to create easy-to-use dashboard to report learning costs and hours of training.

I always have many lines (1 for pedagological cost, 1 for logistical costs etc for each type of learning type).

Does anyone face the same issue ?

First question that would also help me a lot : How can I combine to 2 types of costs in one column ? ==> combine 2 "Cost Details"."Cost Details Line Amount" in one column (CASE WHEN "Cost Details"."Cost Details Line Type" = 'Logistical cost'  + CASE WHEN "Cost Details"."Cost Details Line Type" = 'Pedagogical cost') 

Thanks,

Jacqueline