Placeholder

Customer Forum

Reporting a percentage in a grouped summary view

Rob Posted: 2018-05-23 10:05

Hi There
I am trying to produce a report which shows a breakdown of categories shown by percentage, however upon creating a summary view I am unable to sum the times from the column in the details view without its figures being broken down further by the grouping, I do not want this to happen in this instance, I need to be able to divide the individual categories/groups by the total across ALL the groups, what makes this more frustrating is that the subtotal is shown in a summarised column but this figure is seemingly unavailable to use for a further calculation, please help as this is incredibly frustrating!,

Rob Posted: Wed, 23.05.2018 - 10:39

I resolved this following your previously dispensed advice as per
https://www.workbooks.com/forum/seeing-sub-totals-and-totals-one-report…

Thanks very much!