How to calculate the aggregate balance

ME2021QLIK — Fri, 05 Mar 2021 18:39:46 GMT

Hi there,

I'm trying to set up a pivot table and then a bar chart to show the total and % of utilisation across multiple dimensions and not sure how best to tackle it.

Example data: So I want to calculate how much time (as %) was spent on different activities each month by each Class and Group. So at the student level it's just the time spent divided by the available time of each student. I'm just now sure how to get the aggregate result on a pivot table. When presenting in graph, I'm looking for a bar chart that allows me to view % by Activity across different class (for a particular month) and another bar chart with % by Activity across different months.

Any help would be greatly appreciated. Many thanks.

Group	Class	Activity	Student	Available time per week	Week	Time Spent
A	1	Act 1	S1	28	1	20
B	1	Act 2	S2	35	1	5
C	2	Act 2	S3	7	1	6
D	1	Act 1	S4	7	1	0
B	3	Act 3	S2	35	1	30
B	1	Act 1	S2	35	1	5
A	1	Act 2	S1	28	2	14
F	2	Act 1	S5	14	2	15

Re: How to calculate the aggregate balance

Saravanan_Desingh — Sat, 06 Mar 2021 02:01:27 GMT

Are you looking something like this?

Re: How to calculate the aggregate balance

ME2021QLIK — Tue, 09 Mar 2021 12:41:35 GMT

Hi,

I have the information per week but I need to present it per month.

Also for the bar chart I also need to have % by activity for each Class.

And activity % each month.

For example something like the below with each column is a month, then I can drill it down to Class for each month.

topic Re: How to calculate the aggregate balance in App Development

How to calculate the aggregate balance

Re: How to calculate the aggregate balance

Re: How to calculate the aggregate balance