Forum Discussion

Magichi's avatar
Magichi
Regular Visitor
9 years ago
Solved

How to create a report like this?

I want to sum value of 'Actual','Approved Budget','LE' and group by 'Funded'   Like above picture   Can anyone help me?
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

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