How to create a report like this?

[Magichi]

I want to sum value of 'Actual','Approved Budget','LE' and group by 'Funded'

Like above picture

Can anyone help me?

[MFelix · Accepted solution]

Hi @Magichi,

First of all you need to edit your query and unpivot the Actuals/Approved/LE columns this will give you the following setup on your table:

Next add a stacked bar chart with the following columns in each field:

Axis - Type

Legend - Funded

Value - Value

This should give you waht you need:

Regards,

MFelix