Need to display the totals of a column seperately

Question

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 !

3174977 · Answer

Thank you

cesar.advincula.o · Answer

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