Need to display the totals of a column seperately

3174977

Hi All,

I have a report with columns type(Actual/plan) & hours. Currently we are displaying the grand total of all hours (Actual & Plan). But the users wanted to see grand total of actual and plan hours separately. is that possible if so how can we achieve this. Please see the below ,

Is there any way to separate the grand total for actual and plan..

Thanks !

cesar.advincula.o

Hello,

Yes its possible, use a "pivot table" graph:

1. put your "type" column

2. your mesure in this section

3, Set up your rows, sum total by rows

  

Kind Regards

3174977

Thank you