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

1 Reply

  • MFelix's avatar
    MFelix
    Super 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